STORE
STORE SET filename [CRE[ATE] | REP[LACE] | APP[END]]

Saves attributes of the current SQL*Plus environment in a file as a list of SET commands.

Keywords

filename

Specifies the name of an operating system file that will contain the SET commands.

CREATE

Creates a new file; the filename must not exist if this option is specified.

REPLACE

Replaces the contents of any existing file; if the filename does not exist, it is created.

APPEND

Adds the contents of the buffer to the end of the specified file.

Get Oracle SQL: the Essential 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.