12.6 APPEND

Syntax

A[PPEND] text

where text represents the text to append.

Adds specified text to the end of the current line in the SQL buffer.

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).

Examples

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
1* SELECT DEPARTMENT_ID

Now enter APPEND:

APPEND , CITY
1
1* SELECT DEPARTMENT_ID, CITY

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.