Global variables can have literal, NULL, or system constant default
values.
Default Value
(1)
|--+-| Literal Number |--------------------------------+--------|
| (2) |
+-| Quoted String |---------------------------------+
| (3) |
+-| Literal Interval |------------------------------+
| (4) |
+-| Literal Datetime |------------------------------+
+-+-CURRENT-+--+----------------------------------+-+
| '-SYSDATE-' | (5) | |
| '-| DATETIME Field Qualifier |-----' |
'-+-CURRENT_USER-+----------------------------------'
+-DBSERVERNAME-+
+-SITENAME-----+
+-TODAY--------+
+-USER---------+
'-NULL---------'
Notes:
- See Literal Number
- See Quoted String
- See Literal INTERVAL
- See Literal DATETIME
- See DATETIME Field Qualifier
If you specify a default value, the global variable is initialized
with the specified value.