Database Reference
In-Depth Information
Figure 1.18
SQL*Plus
Worksheet Has
Useful Windows-
like Functions.
5. Click the Execute icon. The icon looks like a lightning bolt and is
located on the left side of the window. The results of the query
scroll down on the lower pane. Figure 1.18 shows the SQL*Plus
Worksheet window at this point.
6. Modify the query by changing “FILE_NAME” to “MAX-
BYTES.” Notice that you can edit directly in this tool without
resorting to an editor.
7. Run the changed command by clicking the Execute icon again.
The results appear in the lower pane.
8. Hold your mouse over each of the icons on the left side of the
window to see the other handy functions available in this tool.
For example, the icon just below the Execute icon can list up to
50 previous SQL commands.
9. Exit this tool by clicking the
X
in the top window or typing EXIT
and clicking the Execute icon.
The SQL*Plus Worksheet may be the most versatile of the SQL*Plus
variations. You may find it easier to work with than SQL*Plus Windows or
command-line versions and capable of more features than the Web version
found in the next section.
