../E16604-03.epub /> ../E16604-03.mobi />

STORE

Syntax

STORE SET file_name[.ext] [ CRE[ATE | REP[LACE] | APP[END]]

Saves attributes of the current SQL*Plus environment in a script.

Terms

See SAVE for information on the other terms and clauses in the STORE command syntax.

SET

Saves the values of the system variables.

Usage

This command creates a script which can be executed with the START, @ (at sign) or @@ (double at sign) commands.

If you want to store a file under a name identical to a STORE command clause (that is, CREATE, REPLACE or APPEND), you must put the name in single quotes or specify a file extension.

Examples

To store the current SQL*Plus system variables in a file named DEFAULTENV with the default command-file extension, enter

STORE SET DEFAULTENV

To append the current SQL*Plus system variables to an existing file called DEFAULTENV with the extension OLD, enter

STORE SET DEFAULTENV.OLD APPEND