SQL Developer Concepts and Usage

Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. You can browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export (unload) data; and view and create reports.

You can connect to any target Oracle database schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

You can connect to schemas for selected third-party (non-Oracle) databases, such as MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, and IBM DB2, and view metadata and data in these databases; and you can migrate third-party databases to Oracle.

See Related Topics to learn about key features of SQL Developer.

Related Topics

Getting Started with SQL Developer

SQL Developer User Interface

Database Objects

Database Connections

Entering and Modifying Data

Running and Debugging Functions and Procedures

Using the SQL Worksheet

Using Snippets to Insert Code Fragments

Finding Database Objects

Using Recent Objects

Using Versioning

Using DBA Features in SQL Developer

Scheduling Jobs Using SQL Developer

Using the Cart

Spatial Support in SQL Developer

Change Manager Support in SQL Developer

Application Express Listener Administration

RESTful Services Administration

SQL Developer Reports

SQL Developer Preferences

Location of User-Related Information

Command-Line Interface for SQL Developer

Data Modeler in SQL Developer

Oracle TimesTen In-Memory Database Support

Using the Help

SQL Developer Usage Suggestions

Supplementary Oracle Database Information

For More Information About SQL Developer

SQL Developer: Migrating Third-Party Databases

SQL Developer: Unit Testing

SQL Developer Tutorial: Creating Objects for a Small Database