Name

SAVE — Not available in iSQL*Plus

Synopsis

The SAVE command writes the contents of the SQL buffer to an operating system file.

Syntax

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

Parameters

SAV[E]

Is the command, which may be abbreviated SAV.

filename

Is the filename, including the path and extension, to which you want to write the buffer contents.

CRE[ATE]

Causes the operation to succeed only if the file doesn't exist. This is the default setting.

REP[LACE]

Overwrites any existing file of the same name.

APP[END]

Appends the contents of the buffer to the file.

SAVE, and all the other editing commands, are described in Chapter 2.

Get Oracle SQL*Plus: The Definitive Guide, 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.