Name

GET — Not available in iSQL*Plus

Synopsis

The GET command reads a SQL statement from a file and loads it into the buffer.

Syntax

GET filename [LIS[T] | NOL[IST]]

Parameters

filename

Is the name of the file containing the SQL statement you want to load. This can be any filename, including path and extension, that your operating system recognizes.

LI[ST]

Causes SQL*Plus to display the buffer after loading the file. This is the default.

NOL[IST]

Causes SQL*Plus to load the file without displaying it.

GET, 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.