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 | UTCDIFF
|
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 database instance |
|
SYSDBA [(<user name>)] |
SYSDBA of the database instance |
|
[<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. |
|
UTCDIFF |
Time difference in hours (in data type FIXED(4,2)) between your local time value and the UTC time value (Greenwich Mean Time) |