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)