Name

SAVE

Synopsis

SAV[E] filename [CRE[ATE] | REP[LACE] | 
   APP[END]]

The SAVE command writes the contents of the SQL buffer to an operating-system file. For example:

SAVE my_query.sql
SAVE my_query REPLACE

Parameters

filename

Is the name of the file to which you want to write the buffer contents.

CRE[ATE]

Causes the operation to succeed only if the file does not already exist. This is the default.

REP[LACE]

Overwrites any existing file of the same name.

APP[END]

Appends the contents of the buffer to the file.

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.