|SQL*Plus User's Guide and Reference
Part Number A88827-02
Command Reference, 25 of 52
GET file_name[.ext] [LIS[T]|NOL[IST]]
Loads a host operating system file into the SQL buffer.
Refer to the following list for a description of each term or clause:
If you do not specify a file extension, SQL*Plus assumes the default command-file extension (normally SQL). For information on changing the default extension, see the SUFFIX variable of the SET command in this chapter.
If the filename you specify contains the word list or the word file, the name must be in double quotes. SQL*Plus searches for the file in the current working directory.
The operating system file should contain a single SQL statement or PL/SQL block. The statement should not be terminated with a semicolon. If a SQL*Plus command or more than one SQL statement or PL/SQL block is loaded into the SQL buffer from an operating system file, an error occurs when the RUN or slash (/) command is used to execute the buffer.
The GET command can be used to load files created with the SAVE command. See the SAVE command in this chapter for more information.
To load a file called YEARENDRPT with the extension SQL into the buffer, enter