Name

GET

Synopsis

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

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

GET my_report.sql
GET my_report NOLIST

Parameters

filename

Is the name of the file containing the SQL statement you want to load.

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 Oracle SQL*Plus Pocket Reference 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.