René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

save [SQL*Plus]

save [file] file-name [create|replace|append]
Saves the content of the SQL*Plus buffer into the file named file-name.suffix.
The suffix is .sql unless it has been specified with set suffix.
The file can be loaded again into the SQL*Plus buffer with get.

Restriction level

The save command won't work if the restriction level is set to at least 2:
C:>sqlplus -r 2 rene/rene

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 17 21:10:39 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

RENE> save xyz
SP2-0738: Restricted command "save" not available
RENE>