Oracle SQL*Plus Pocket Reference

Name

INPUT

Synopsis

I[NPUT] [text]

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 of INPUT being used:

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.