The SQLPlus Worksheet

The SQL*Plus Worksheet

You can also enter SQL statements using the SQL*Plus worksheet, which has an improved user interface. If you are using Windows, you can start SQL*Plus by clicking Start and selecting Programs Oracle Application Development SQL*Plus Worksheet. Figure 1-4 shows the SQL*Plus Worksheet window once you ve logged on to the database. If you have SQL*Plus Worksheet installed, go ahead and log on to the database as the scott user, enter the SELECT SYSDATE FROM dual, query, and select Execute from the Worksheet menu.

Figure 1-4: Executing a SQL SELECT statement using the SQL*Plus worksheet

Tip  

You can also execute a statement by clicking the Execute button (it has a lightning bolt on it). You can also press F5 on your keyboard to execute a statement.

Figure 1-4 shows the result of running the query that retrieves the current date. Notice that the top part of the window shows the SQL statement executed and the lower part shows the result of the executed statement.

In the next section, you ll learn how to create a fictional store database schema.