Q) Write and explain an example of ‘CREATE SEQUENCE’.
ANS:
Example-3 CREATE SEQUENCE seq_2 MINVALUE 10 MAXVALUE 1000 START WITH 10 INCREMENT BY 5 ; |
Explaination-
· Use the CREATE SEQUENCE statement
to create a Sequence.
· Use sequences to
automatically generate primary key values.
· Sequence start with 10 at the interval of 5 upto 1000.
(Just like – 10,15,20,25…….1000)
0 Comments
If you have any suggestion or doubt, please ask me.
Emoji