|SQL*Plus User's Guide and Reference
Part Number A88827-02
Command Reference, 28 of 52
Adds one or more new lines of text after the current line in the buffer.
Refer to the following for a description of the term or clause:
To add several lines, enter INPUT with no text. INPUT prompts you for each line. To leave INPUT, enter a null (empty) line or a period.
If you enter a line number at the command prompt larger than the number of lines in the buffer, and follow the number with text, SQL*Plus adds the text in a new line at the end of the buffer. If you specify zero (0) for the line number and follow the zero with text, then SQL*Plus inserts the line at the beginning of the buffer (that line becomes line 1).
Assume the SQL buffer contains the following command:
To add an ORDER BY clause to the query, enter
LIST 2 ensures that line 2 is the current line. INPUT adds a new line containing the ORDER BY clause after the current line. The SQL buffer now contains the following lines:
1 SELECT LAST_NAME, DEPARTMENT_ID, SALARY, COMMISSION_PCT 2 FROM EMP_DETAILS_VIEW 3* ORDER BY LAST_NAME
To add a two-line WHERE clause, enter
INPUT prompts you for new lines until you enter an empty line or a period. The SQL buffer now contains the following lines: