INPUT

Inserts one or more lines of text into the buffer. The lines are inserted after the current line.

I[NPUT] [text]

where:

I[NPUT]

Is the command, which may be abbreviated to I. 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. These are all inserted into the buffer following the current line. Press ENTER on a blank line to terminate insert mode.

text

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

INPUT, and all the other editing commands, are described in Chapter 2.

Get Oracle SQL*Plus: The Definitive Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.