Home arrow Oracle arrow How to Use the Oracle SQL Developer Tool

How to Use the Oracle SQL Developer Tool

Now there is a standalone graphic user interface that you can use to develop your SQL with Oracle databases. The many things you do in Oracle 10G XE can also be carried out with the Oracle SQL Developer. It is expected to enhance productivity in your Oracle applications.

  1. How to Use the Oracle SQL Developer Tool
  2. Connecting to databases
  3. Verifying objects in the database
  4. Creating a SQL Query
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 40
February 28, 2007

print this article



You can use Oracle SQL Developer to connect, run, and debug PL/SQL. It can run on at least three different operating systems. This tutorial exposes you to this useful interface and shows you some basic tasks that gets you started with this tool. With Oracle 10 XE and this tool, you will have expanded your skill set.

Downloading and installing the Oracle SQL Developer

This version 1.1 December release can be downloaded from the Oracle site after accepting the license agreement. This 63MB down load will install a zip folder which you may place in any directory. From the unzipped contents, double click on the SQLDeveloper.exe.

The User Interface

On a Windows machine you may get a security warning which you may safely override and click on Run. This opens up the splash window shown in the next picture followed by the Oracle SQL Developer interface shown in the picture that follows.

In this highly reduced image you may not be able to discern the various details. It has a main menu at the very top where you can access File, Edit, View, Navigate, Run, Debug, Source, Tools and Help menus. Immediately below the main menu on the left you have a tabbed window with two tabs, Connections and Reports. This will be the item you have to contend with since most things start only after establishing a connection. The connection brings with it the various related objects in the databases. The next picture shows the drop-down of the View main menu, where you can see other details such as links to the debugger, reports, connections and snippets.

Snippets are often-used SQL statements or clauses that you may want to insert. You may also save your snippets by clicking on the bright green plus sign in the window shown, which opens up the superposed Save Snippet  window.

In the Run menu item you can run files as well as look at the Execution Profile. The debug menu item has all the necessary hooks to toggling break points: step into, step over, step out and step to End of methods, etc., including garbage collection and clean up as shown in the next picture. Tools give access to External Tools that can be launched, Exports both DDL and data, schema diff, etc. Help gives you both full text search and indexed search.

>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: