You can use SQL Developer to issue SQL and PL/SQL statements. All SQL and PL/SQL commands are supported as they are passed directly from the SQL Worksheet to the Oracle Database.
To start SQL Developer:
- From the Start menu, select All Programs, then Oracle - HOMENAME, then Application Development, and then SQL Developer.
- If you are prompted to enter the full path name for java.exe, click Browse and find
java.exe. For example,
- Once SQL Developer starts, perform the following steps:
Select New Connection.
In the New/Select Database Connection dialog box, enter a Connection name, username, password, and for the host string, the name of the database to which you want to connect.
Once connected, you can view, create, modify, and delete the database objects using the Connection Navigator or issue any SQL or PL/SQL command using a SQL Worksheet (From the Tools menu, select SQL Worksheet).
SQL*Plus commands have to be interpreted by the SQL Worksheet before being passed to the database. The SQL Worksheet currently supports many SQL*Plus commands. SQL*Plus commands which are not supported by the SQL Worksheet are ignored and are not sent to the Oracle Database.