|SQL*Plus User's Guide and Reference
Command Reference, 7 of 52
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:
Represents the text you wish to append. If you wish to separate text from the preceding characters with a space, enter two spaces between APPEND and text.
To APPEND text that ends with a semicolon, end the command with two semicolons (SQL*Plus interprets a single semicolon as an optional command terminator).
To append a space and the column name DEPT to the second line of the buffer, make that line the current line by listing the line as follows:
Now enter APPEND:
Notice the double space between APPEND and DEPT. 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
SQL*Plus appends the first semicolon to the line and interprets the second as the terminator for the APPEND command.