Specifying values (value spec)
Values can be specified (
value spec ) by specifying literals, parameter specifications, or a series of keywords.Syntax
<value spec> ::= <literal> | <parameter spec>
| NULL | USER | USERGROUP | LOCALSYSDBA
| SYSDBA [(<user name>)] | SYSDBA [(<usergroup name>)]
| [<owner>.]<sequence name>.NEXTVAL | [<owner>.]<sequence name>.CURRVAL
| DATE | TIME | TIMESTAMP | TIMEZONE | TRUE | FALSE | TRANSACTION
literal |
Literal |
parameter spec |
Parameter spec |
NULL |
NULL value |
USER |
Current user name |
USERGROUP |
Name of the usergroup to which the user calling the SQL statement belongs. If the user does not belong to a user group, the user name is displayed. |
LOCALSYSDBA |
SYSDBA of the serverdb |
SYSDBA [(<user name>)] |
SYSDBA of the serverdb |
[<owner>.]<sequence name>.NEXTVAL |
Next value generated for the specified sequence name (of the owner in question). |
[<owner>.]<sequence name>.CURRVAL |
Value generated last for the specified sequence name using [<owner>.]<sequence name>.NEXTVAL . |
DATE |
Current date |
TIME |
Current time |
TIMESTAMP |
Current timestamp |
TIMEZONE |
Time zone. This value is assigned the value 0 and cannot be modified. |
TRUE | FALSE |
Corresponding value of a column of the data type BOOLEAN |
TRANSACTION |
Identification of the current transaction. This is a value of data type CHAR(10) BYTE. |