(For more information, see Section 1.20, "SQL Developer Reports".) Icons above the Connections node and metadata tree perform the following actions on the currently selected object: The metadata tree in the Connections pane displays all the objects (categorized by object type) accessible to the defined connections.
For example, for tables the tabs are Columns, Data (for seeing and modifying the data itself), Indexes, Constraints, and so on; and you can click a column heading under a tab to sort the grid rows by the values in that column.For most objects, the tabs include SQL, which displays the SQL statement for creating the object.You can export (unload) data from a detail pane or from the results of a SQL Worksheet operation or a report by using the context menu and selecting area is used for feedback information as appropriate (for example, results of an action, or error or warning messages).If this area is not already visible, you can display is by clicking View and then Log.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.
See Section 1.12, "Using Versioning" for more information.
The commands on the Team menu depend on which version management and source control systems are available for use with SQL Developer. : Enables you to compare two schemas to find differences between objects of the same type and name (for example, tables named CUSTOMERS) in two different schemas, and optionally to update the objects in the destination schema to reflect differences in the source schema (see the Database Differences interface).
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.
The : Controls the display of the following toolbars: Main toolbar (under the SQL Developer menus), the Connections Navigator toolbar, the DBA navigator toolbar, the Data Miner Workflow Property Inspector toolbar, and (if a package or subprogram is open) the Code Editor toolbar.