Updated: Nov 2009 for SQL Developer 2.1
How to use the SQL Worksheet to enter SQL and SQL*Plus commands
Table of Contents
Oracle SQL Developer provides a SQL Worksheet that you can use to query data, by writing simple or complex SQL statements. In this How-To, we look at the most basic of these, select all the data in a table, and restricting this query by reducing the columns or rows you retrieve.
3.1. Write a Select Statement
Once you have a database connection, you are ready to browse the schema, query and modify data.
3.2. Retrieve Columns
Instead of selecting all the columns from a table, you can itemize them, selecting only the data you require.
3.3. Retrieve Rows
Often you want to restrict the number of records returned. You add a Where Clause to do this. These can be complex and involved. We will start with the most basic.
The SQL Worksheet allows you to use a selection of SQL*Plus commands. SQL*Plus commands have to be interpreted by the SQL Worksheet before being passed to the database. Some commands are not supported and are hence ignored and are not sent to the Oracle database. For a list of unsupported SQL*Plus commands, see SQL Developer on OTN.