Term: CURRVAL

Definition:
The Oracle CURRVAL function is used to access the current value of the specified sequence. Note that CURRVAL can only be used if NEXTVAL has been referenced in the current user session at least once.

You cannot use CURRVAL and NEXTVAL in the following constructs:

• A subquery in a DELETE, SELECT, or UPDATE statement
  
• A query of a view or of a materialized view
  
• A SELECT statement with the DISTINCT operator
  
• A SELECT statement with a GROUP BY clause or ORDER_BY clause
  
• A SELECT statement that is combined with another SELECT statement with the UNION, INTERSECT, or MINUS set operator
  
• The WHERE clause of a SELECT statement
  
• DEFAULT value of a column in a CREATE TABLE or ALTER TABLE statement
  
• The condition of a CHECK CONSTRAINT

CREATE SEQUENCE seq_2 

   INCREMENT BY 1 START WITH 1 

   MAXVALUE 50 MINVALUE 0 

   NOCYCLE CACHE 20 ORDER;



CREATE TABLE table1 (col1 int, col2 int);

INSERT INTO table1 VALUES (0, 0);

• Oracle Sequences: CURRVAL Examples