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.