Question: Create sequence seq 1 Increment by 1 0 Maxvalue 2 0 0 Cycle Nocache; When you execute the sequence it generate numbers upto a maximum

Create sequence seq1
Increment by 10
Maxvalue 200
Cycle
Nocache;
When you execute the sequence it generate numbers upto a maximum of 200. After issuing the following SQL statement:
Select seq1.nextval from dual;
What is displayed by the select statement?
1.1
2.10
3.100
4. An error

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!