Oracle SQL Developer 2.1
上QQ阅读APP看书,第一时间看更新

Who this book is for

This book provides you with in-depth detail about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. It will also make you more productive in some of the more mundane tasks, while providing you with an extensible environment to support your ongoing needs.

No attempt is made to teach Oracle, SQL, or PL/SQL, or to suggest best practices. However, if you are new to the environment, SQL Developer should ably assist you in getting familiar with the database, SQL, and PL/SQL. We'll show you how to create data models and extend existing data designs. We do not teach data modeling and design. Additionally, no part of the book is focused on using non-Oracle databases, except when browsing or importing objects from these for the purpose of migration.

If you have ever accessed an Oracle Database for information on any database objects you are working with, such as tables, constraints, data, or PL/SQL code, whether you are building applications, doing data analysis, or just working with database structures, then you can use SQL Developer for these tasks and this book might be for you! If you are adept with SQL and PL/SQL, know your way around the database, and you're a command-line user, you might be intrigued and we hope that you can dip into this book on an ad hoc basis to get you started and on the road to a "GUI life". We're aware that you'll never fully move from the command-line, but you may well find that using the utilities SQL Developer provides, frees up some of your time to build a few extensions, providing an interface for the utilities you almost certainly already have! For those of you familiar with any of the many GUI tools available today, this book can help you with the details and specifics that make SQL Developer popular.

In general, you'll get more out of the book if you know SQL, PL/SQL, and have a general familiarity with Oracle concepts. There is excellent Oracle Documentation available online, so you can access those if we move into an area that is new to you.