SET ┬> 
C
U
R
R
E
N
C
Y
S
I
G
N currency-char ─────────────────────────────┬>
     ├> 
D
A
T
E 
F
O
R
M
A
T ┬> 
D
A
T
E date-number ─┬────────────>─────────┬┤
     │              │                    └─>,  
T
I
M
E time-number ┘│
     │              └> 
T
I
M
E time-number ─┬────────────>─────────┬┤
     │                                   └─>,  
D
A
T
E date-number ┘│
     ├> 
D
E
F
A
U
L
T 
C
O
N
S
T
R
A
I
N
T typebox (M)typebox (O)typebox (D)typebox (E) ─┬─> 
O
N ──┬──────────────────────┤
     │                           └─> 
O
F
F ─┘                      │
     ├> 
D
I
C
T
I
O
N
A
R
Y ──> path-name ────────────────────────────────┤
     ├> 
D
I
G
I
T 
S
E
P
A
R
A
T
O
R digit-sep-char ──────────────────────────┤
     ├> 
E
D
I
T ───┬──> 
K
E
E
P ───> n ──┬─────────────────────────────┤
     │          ├──> 
N
O
K
E
E
P ───────┤                             │
     │          └──> 
P
U
R
G
E ────────┘                             │
     ├> 
L
A
N
G
U
A
G
E language-name ──────────────────────────────────┤
     ├> 
L
I
N
E 
L
E
N
G
T
H ──> n ───────────────────────────────────────┤
     ├> 
O
U
T
P
U
T ────┬────────>────────┬───────────────────────────┤
     │             └──> file-spec ───┘                           │
     ├> 
N
O
O
U
T
P
U
T ────────────────────────────────────────────────┤
     ├> 
R
A
D
I
X typebox (P)typebox (O)typebox (I)typebox (N)typebox (T) radix-char ──────────────────────────────────┤
     ├> 
V
E
R
I
F
Y ──────────────────────────────────────────────────┤
     └> 
N
O
V
E
R
I
F
Y ────────────────────────────────────────────────┘

Additional information available:

ALL_CONSTRAINTSTRANSACTION

CURRENCY to DIGITEDIT to VERIFY

 Type HELP SET_ALL_CONSTRAINT at the SQL> prompt for help on SET
 ALL CONSTRAINTS.

 SET CURRENCY SIGN specifies the character SQL displays for the
 dollar sign ($) edit string character in column definitions.

 SET DATE FORMAT specifies the input and display format for
 either date values, time values, or both.

 SET DEFAULT CONSTRAINT MODE changes the initial constraint
 setting for any transactions starting after the current
 transaction.

 Setting constraints ON causes all the affected constraints to be
 evaluated immediately, as well as at the end of each statement.
 Setting constraints OFF causes constraint evaluation to be
 deferred until commit time.  <P> Before you execute the SET
 DEFAULT CONSTRAINT MODE statement, the default mode for
 constraints will be set at OFF.  After you execute the SET
 DEFAULT CONSTRAINT MODE statement, any subsequent transactions
 will have the initial constraint evaluation mode that you set.

 SET DICTIONARY changes your default data dictionary dictionary
 directory to the path name you specify.

 SET DIGIT SEPARATOR specifies the character SQL displays for the
 comma (,) edit string character in column definitions.

 SET EDIT controls the size of the editing buffer that you create
 when you use the EDIT statement with a wildcard as the argument.
 The default is 20.  SET EDIT NOKEEP is equivalent to SET EDIT
 KEEP 0.  If you use this form of the statement and you type EDIT
 or EDIT *, your editing buffer is empty.  SET EDIT PURGE retains
 the value of the KEEP parameter but purges all the previous
 statements.

 SET LANGUAGE changes the language to be used for month
 abbreviations in date and time input and display.

 SET LINE LENGTH n specifies an alternate line length (n) for SQL
 output.  For n, you may use any number up to 65,535.

 SET OUTPUT file-spec starts a log file of the SQL statements you
 issue and their results.  SET NOOUTPUT suspends writing to the
 output file.

 SET RADIX POINT specifies the character SQL displays for the
 decimal point (.) edit string character in column definitions.

 SET VERIFY displays indirect command files at your terminal as
 you run them.  SET NOVERIFY disables display or indirect command
 files.  NOVERIFY is the default setting.

 Type HELP SET_TRANSACTION at the SQL prompt for help on SET
 TRANSACTION.