Name

INPUT — Not available in iSQL*Plus

Synopsis

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

Syntax

I[NPUT] [text]

Parameters

I[NPUT]

Is the command, which may be abbreviated I. When you issue the INPUT 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, 2nd Edition 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.