The sequence keywords CURVAL and NEXTVAL can’t be used in:
- the condition of a CHECK constraint
- the DEFAULT value of a table column
- the WHERE clause of a SELECT statement
You may also like
What is wrong with the above statement? The Answer: It is not legitimate to specify a length for LOB data types ( […]
TIMESTAMP WITH TIME ZONE contains all of the values of TIMESTAMP as well as time zone displacement value. Data is normalized to […]
You can’t apply a TO_CHAR() function to an argument with CHAR data type because 10-JAN-16 is already a CHAR literal. It will generate an […]
This is Oracle 12c feature. Prior to 12c, the DEFAULT for a column would not be applied if you explicitly (or implicitly) inserted a […]