Oracle SQL Plus Pocket Reference, 2nd Edition

Name

APPEND

Synopsis

A[PPEND] text

APPEND (not supported in iSQL*Plus) is an editing command that lets you add text onto the end of the current line in the SQL buffer. For example:

SQL> L
  1* SELECT *
SQL> a  FROM dual
  1* SELECT * FROM dual

The text is the text you want appended to the current line.

Note

Use two spaces after the APPEND command if you want your appended string to begin with one space.