SQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88827-02 |
|
Command Reference, 7 of 52
A[PPEND] text
Adds specified text to the end of the current line in the SQL buffer.
Refer to the following for a description of the term or clause:
text
To append a space and the column name CITY to the first line of the buffer, make that line the current line by listing the line as follows:
1 1* SELECT DEPARTMENT_ID
Now enter APPEND:
APPEND CITY 1 1* SELECT DEPARTMENT_ID, CITY
Notice the double space between APPEND and CITY. The first space separates APPEND from the characters to be appended; the second space becomes the first appended character.
To append a semicolon to the line, enter
APPEND ;;
SQL*Plus appends the first semicolon to the line and interprets the second as the terminator for the APPEND command.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|