Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seql -START WITH 100 -INCREMENT BY 10 -MAXVALUE 200 -CYCLE -NOCACHE;The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:SELECT seql.nextval FROM dual;What is displayed by the SELECT statement?
A. 1
B. 10
C. 100
D. an error
Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seql -START WITH 100 -INCREMENT BY 10 -MAXVALUE 200 -CY
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am