|SQL*Plus® User's Guide and Reference
Part Number E16604-02
where text represents the text to append.
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 comma delimiter, 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* SELECT DEPARTMENT_ID
Now enter APPEND:
APPEND , CITY 1
1* SELECT DEPARTMENT_ID, CITY
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.