PacktLib: Oracle SQL Developer 2.1

Oracle SQL Developer 2.1

Credits

About the Author

Acknowledgement

About the Reviewers

Preface

Getting Started with SQL Developer

Preparing your environment

A quick overview

Navigating around SQL Developer

Finding more help

Summary

Browsing and Editing Database Objects and Data

Browsing objects

Creating and updating database objects

Summary

Working with the SQL Worksheet

Introducing the SQL Worksheet

Writing and executing commands

Using the Query Builder

Summary

The Power of SQL Reports

Introducing SQL Developer reports

Browsing shipped reports

Creating your own reports

Sharing reports

Summary

Working with PL/SQL

Creating PL/SQL code

Creating and compiling PL/SQL program units

Editing code

Debugging PL/SQL

Summary

SQL and PL/SQL Tuning Tools

Support for tuning code in the SQL Worksheet

Additional performance tuning tools

Profiling PL/SQL

Summary

Managing Files

Introducing source code control

Getting started

Working with files under version control

Summary

Importing, Exporting, and Working with Data

Exporting data

Importing data

Using the Database Copy wizard

Comparing schemas

Summary

Database Connections and JDBC Drivers

Working with Oracle connections

Creating non-Oracle database connections

Summary

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

Summary

Extending SQL Developer

Introducing extensibility

SQL Developer XML extension types

Reviewing an example

Working with extensions

Summary

Working with Application Express

Setting the scene

Summary

Working with SQL Developer Migrations

Introducing SQL Developer Migrations

Setting up your environment

Migrating

Additional migration activities

Summary