Oracle SQL Plus Pocket Reference, 2nd Edition

Name

INPUT

Synopsis

I[NPUT] [text]

The INPUT command (not supported in iSQL*Plus) inserts one or more lines of text into the buffer. The lines are inserted after the current line. When you issue the INSERT command with no text after it, SQL*Plus puts you in insert mode, allowing you to type as many lines as you like. Here’s an example:

SQL> L
  1  SELECT
  2* FROM dual
SQL> L 1
  1* SELECT
SQL> I *
SQL> L
  1  SELECT
  2  *
  3* FROM dual

The text is the text you want to insert. Use this if you are inserting only one line.