Database Reference
In-Depth Information
Figure 1.15
SQL*Plus in
Windows Mode
Has a Scroll Bar
and Menu.
and report feedback are standard parts of every mode of
SQL*Plus; however, the scroll bar and the menu are features of
the Windows mode and not of the command-line mode. Some
operating systems will allow configuration changes to allow addi-
tion of scroll bars to command-line windows.
7.
Click on Edit in the top menu and invoke the editor. A window
appears with an editing program and the text of the query you
wrote ready for editing. In Windows, the default editor is Note-
pad. In UNIX, Linux, and other operating systems, the default
editor can be configured in a user profile.
8.
The editor can be used to change the command you created while
working in SQL*Plus. You can retrieve files with SQL commands
in them using the File/Open command on the menu. Selecting
the File/Run command from the menu will execute the most
recent SQL command. Modify the query by removing the CRE-
ATED column from the query.
9.
Save the file and exit the editor. The modified query now appears
on the screen, ready to run if you choose. Figure 1.16 shows what
your SQL*Plus screen should look like now.
10.
Before running the command, select File/Spool/Spool File from
the menu. A window opens in which you can select the file name
and location. This file will contain everything you type and
SQL*Plus returns from the moment you return to SQL*Plus
