For example, if you open a file, it is displayed in a SQL Worksheet window.
The Files navigator is especially useful if you are using versioning with SQL Developer (see Section 1.10, "Using Versioning").
If this area is not already visible, you can display is by clicking View and then Log.
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.
However, you can customize many aspects of the appearance and behavior of SQL Developer by setting preferences (see Section 1.18).
If you ever need to restore the default interface, see Section 1.2.2, "Restoring the Original "Look and Feel"".
You can connect to schemas for selected third-party (non-Oracle) databases, such as My SQL, 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.
This chapter contains the following major sections: Section 1.1, "Installing and Getting Started with SQL Developer" Section 1.2, "SQL Developer User Interface" Section 1.3, "Database Objects" Section 1.4, "Database Connections" Section 1.5, "Entering and Modifying Data" Section 1.6, "Running and Debugging Functions and Procedures" Section 1.7, "Using the SQL Worksheet" Section 1.8, "Using Snippets to Insert Code Fragments" Section 1.9, "Finding Database Objects" Section 1.10, "Using Versioning" Section 1.11, "Using DBA Features in SQL Developer" Section 1.12, "Scheduling Jobs Using SQL Developer" Section 1.13, "Deploying Objects Using the Cart" Section 1.14, "Spatial Support in SQL Developer" Section 1.15, "Change Manager Support in SQL Developer" Section 1.16, "Application Express Listener Administration" Section 1.17, "SQL Developer Reports" Section 1.18, "SQL Developer Preferences" Section 1.19, "Location of User-Related Information" Section 1.20, "Data Modeler in SQL Developer" Section 1.21, "Oracle Times Ten In-Memory Database Support" Section 1.22, "Using the Help" Section 1.23, "Tip of the Day" Section 1.24, "For More Information" Note: This text explains the default interface.
To select an object, expand the appropriate tree node or nodes, then click the object.
The right side of the SQL Developer window has tabs and panes for objects that you select or open, as shown in the following figure, which displays information about a table named BOOKS.
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).
Navigate menu Contains options for navigating to panes and in the execution of subprograms.