Free Sample
+ Collection

Oracle SQL Developer 2.1

Sue Harper

Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847196262
Paperback496 pages

About This Book


  • Install, configure, customize, and manage your SQL Developer environment
  • Includes the latest features to enhance productivity and simplify database development
  • Covers reporting, testing, and debugging concepts
  • Meet the new powerful Data Modeling tool – Oracle SQL Developer Data Modeler
  • Detailed code examples and screenshots for easy learning

Who This Book Is For

This book is for Oracle developers who want to ease their database development, and enhance their productivity using Oracle SQL Developer. You should have a programming knowledge of SQL and PL/SQL, and a general familiarity with Oracle database concepts.

Table of Contents

Chapter 1: Getting Started with SQL Developer
Preparing your environment
A quick overview
Navigating around SQL Developer
Finding more help
Chapter 2: Browsing and Editing Database Objects and Data
Browsing objects
Creating and updating database objects
Chapter 3: Working with the SQL Worksheet
Introducing the SQL Worksheet
Writing and executing commands
Using the Query Builder
Chapter 4: The Power of SQL Reports
Introducing SQL Developer reports
Browsing shipped reports
Creating your own reports
Sharing reports
Chapter 5: Working with PL/SQL
Creating PL/SQL code
Creating and compiling PL/SQL program units
Editing code
Debugging PL/SQL
Chapter 6: SQL and PL/SQL Tuning Tools
Support for tuning code in the SQL Worksheet
Additional performance tuning tools
Profiling PL/SQL
Chapter 7: Managing Files
Introducing source code control
Getting started
Working with files under version control
Chapter 8: Importing, Exporting, and Working with Data
Exporting data
Importing data
Using the Database Copy wizard
Comparing schemas
Chapter 9: Database Connections and JDBC Drivers
Working with Oracle connections
Creating non-Oracle database connections
Chapter 10: Introducing SQL Developer Data Modeler
Oracle SQL Developer Data Modeler
Getting started
Working with diagrams and their components
Analysis, design, and generation
Integration with Oracle SQL Developer
Chapter 11: Extending SQL Developer
Introducing extensibility
SQL Developer XML extension types
Reviewing an example
Working with extensions
Chapter 12: Working with Application Express
Setting the scene
Chapter 13: Working with SQL Developer Migrations
Introducing SQL Developer Migrations
Setting up your environment
Additional migration activities

What You Will Learn

  • Build complex queries based on a number of tables using visual Query Builder
  • Assess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reports
  • Create, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL code
  • Integrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back in
  • Enter and execute your SQL, PL/SQL, and SQL*Plus statements with the SQL Worksheet interface
  • Produce easily replicable scripts that copy and move data from one database instance to another, or from one schema to another
  • Create advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databases
  • Create, review, and update database schema designs with SQL Developer Data Modeler
  • Augment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensions
  • Monitor and manage your Application Express applications by integrating with SQL Developer
  • Set up an easy and quick migration environment for your database schema by using the migration repository
  • Browse and review non-Oracle databases, before using the migration environment to migrate and consolidate databases on the Oracle platform

In Detail

As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface.

It’s easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer’s extensible environment to support your ongoing needs

This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.

By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.


Read More