Database Reference
In-Depth Information
Table 1.1
SQL*Plus Line Editing Commands.
Command
Description
c
/old/new
Change old to new characters in current
line.
l
or
list
List the SQL in the buffer.
l
n
Go to line
n
in the SQL buffer.
del
n or
del
* or
del
n m
Delete line
n
in the SQL buffer, or delete
the current line (
*
) or delete lines
n
through
m
.
a
text or
append
text
Add
text
to the end of the current line.
i
or
input
or
i
text or
input
text
Insert a new line after the current line.
Add
text
to the line, if
text
is specified.
Next, you will look at the Windows-like SQL*Plus tool.
1.6.2
SQL*Plus in Windows Mode
This version of SQL*Plus gives you a Windows-like interface with a few
environmental options. However, it still requires you to type a single line at
a time.
To try out SQL*Plus in Windows mode, follow these steps:
1.
If you are using a Windows operating system, start the tool by
clicking Start/Programs/Oracle - Orahome10/Application Devel-
opment/SQL*Plus. If you are using another operating system, go
to a command-line prompt, type sqlplusw, and press Enter.
You will see a Log On window appear. You must log on with
valid credentials now.
2.
Type SYSTEM in the User Name box, the current password for
SYSTEM in the Password box, and your database name in the
Host String box. Figure 1.14 shows the Log On window with the
information filled in. Notice that the password appears as a line of
asterisks. This is to keep your password private.
3.
Click OK to log in. The SQL*Plus window appears. Just like
the command-line version, you see status information and get
