Sql Para Los Novatos

Oracle SQL Developer for Database
Developers
An Oracle White Paper
September 2008

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 .............................................................5Executing 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 EditingPL/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 ...........................................................................................13Migration.......................................................................................................14
Overview ..................................................................................................14
Supported Databases..............................................................................14
The Migration Process ...........................................................................14
TranslatingCode.....................................................................................14
Extensibility..................................................................................................15
A Few Basic Extensions ........................................................................15
Conclusion ........................................................................................................16Oracle SQL Developer for Database Developers

Page 2

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 nonOracle tools for developing and debugging SQL...