Function
specifies a value.
Format
<value spec> ::=
| NULL
| USER
| [<owner>.]<sequence name>.NEXTVAL
| [<owner>.]<sequence name>.CURRVAL
| SYSDATE
| UID
<string spec> ::=
Syntax Rules
none
General Rules
1. The key word NULL denotes the NULL value.
2. The key word USER denotes the name of the current user.
3. [<owner>.]<sequence name>.NEXTVAL denotes the next value that will be generated for the specified <sequence name>. The rule according to which the next value is generated is specified in the <create sequence statement>. The interval between the values is also specified in the <create sequence statement> . Sequences can be used to generate unique values. These are not uninterrupted because values generated in a transaction that is rolled back cannot be reused.
4. [<owner>.]<sequence name>.CURRVAL denotes the last value that was generated for the specified sequence name using [<owner>.]<sequence name>.NEXTVAL.
5. SYSDATE denotes the current date and the current time.
6. UID denotes the user number of a user.
7. For a <string spec>, only <expression>s that denote an alphanumeric value as the result are valid.