Name

GET

Synopsis

GET filename [LIST | NOLIST]]

The GET command (not supported in iSQL*Plus) 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

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

LIST

Displays the buffer after loading the file. This is the default.

NOLIST

Loads the file without displaying it.

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