Audience This guide is intended for those using the Oracle SQL Developer tool. … If you want to get started quickly with SQL Developer, do the short tutorial in Chapter3 … Oracle® Database SQL Developer User’s Guide Release 1.5 E12152-06 March 2009 Provides conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; migrate third-party …

1.1Installing and Getting Started with SQL Developer To install and start SQL Developer, you simply download a ZIP file and unzip it into a desired parent directory or folder, and then type a command or double-click a file name. You should read the Oracle Database SQL Developer Installation Guide before you perform the installation. After you have read the installation guide, the basic steps are: 1. Unzip the SQL Developer kit into a directory (folder) of your choice. This directory location will be referred to as . Unzipping the SQL Developer kit causes a directory named sqldeveloper to be created under the directory. It also causes many files and folders to be placed in and under that directory. If Oracle Database (Release 11 or later) is also installed , a version of SQL Developer is also included and is accessible through the menu system under Oracle. This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer. 2. To start SQL Developer, go to the sqldeveloper directory under the directory, and do one of the following: On Linux and Mac OS X systems, run sh sqldeveloper. sh . On Windows systems, double-click sqldeveloper.exe. If you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For example, on a Windows system the path might have a name similar to C:\Program Files\Java\jdk1.6.0_06\bin\java. exe. 3. If you want to become familiar with SQL Developer concepts before using the interface, read the rest of this chapter before proceeding to the next step. 4. Create at least one database connection (or import some previously exported connections), so that you can view and work with database objects, use the SQL Worksheet, and use other features. To create a new database connection, right-click the Connections node in the Connections navigator, select New Connection , and complete the required entries in the Create/Edit/Select Database Connection dialog box. 5. If you want to get started quickly with SQL Developer, do the short tutorial in Chapter3, “Tutorial: Creating Objects for a Small Database” , or work with your existing database objects.

Download Oracle SQL Developer Users Guide.Pdf