Oracle SQL Developer for Database Developers

Oracle SQL Developer for Database

Developers

An Oracle White Paper

September 2008

Oracle SQL Developer for Database Developers Page 2

Oracle SQL Developer for Database Developers

Introduction........................................................................................................3

Audience .........................................................................................................3

Key Benefits ...................................................................................................3

Architecture....................................................................................................4

Key Features .......................................................................................................4

Managing Connections .................................................................................4

Additional Authentication and Connection Methods .........................5

Grouping Connections ............................................................................5

Exporting Connections............................................................................5

Working with the SQL Worksheet .............................................................5

Executing Statements in the SQL Worksheet ......................................5

Editing Code in the SQL Worksheet.....................................................6

Browsing the Database.................................................................................7

Creating and Editing Schema Objects .......................................................8

Producing SQL Scripts .................................................................................8

Database Export .......................................................................................8

Schema Copy and Compare....................................................................9

PL/SQL Development.................................................................................9

Creating and Editing PL/SQL in the Code Editor .............................9

Running PL/SQL Procedures, Functions, and Packages .................10

Hierarchical Profiler ...............................................................................11

Debugging PL/SQL...............................................................................11

Additional PL/SQL Debugging Features ...........................................12

Remotely Debugging PL/SQL.............................................................12

Database Reporting.....................................................................................13

Version Control ...........................................................................................13

Migration.......................................................................................................14

Overview..................................................................................................14

Supported Databases..............................................................................14

The Migration Process ...........................................................................14

Translating Code.....................................................................................14

Extensibility..................................................................................................15

A Few Basic Extensions ........................................................................15

Conclusion ........................................................................................................16

Oracle SQL Developer for Database Developers Page 3

Oracle SQL Developer for Database Developers

INTRODUCTION

Oracle SQL Developer is a free graphical tool that enhances productivity and

simplifies database development tasks. Designed for Oracle Database developers,

SQL Developer simplifies development cycles and reduces the need to buy non-

Oracle tools for developing and debugging SQL and PL/SQL code. Using SQL

Developer, users can browse, create and modify database objects, run SQL

statements, edit and debug PL/SQL and can run reports from an extensive list of

predefined reports or create their own. Users can also create Database

Connections for non-Oracle databases MySQL, Microsoft SQL Server, Microsoft

Access and Sybase Adaptive Server for object and data browsing and can migrate

the objects and data from these platforms to Oracle.

The addition of this tool underscores Oracle’s commitment to improving the

productivity and supporting the needs of the database developer community.

The initial production release of SQL Developer was in March 2006. The latest

release of SQL Developer is release 1.5.1, available from June 2007. This white

paper is an overview of many of the features available in SQL Developer.

Audience

...