Oracle PLSQL Sequence 22 codes

1 A CYCLE sequence

2 A decrement sequence

3 A NOCYCLE sequence

4 Alter sequence increment

5 Automatically including unique sequence numbers during an INSERT

6 Create a SEQUENCE and retrieve the value

7 Create sequence emps_seq start with 501 increment by 10

8 CREATE SEQUENCE myTableIDSeq INCREMENT BY 1 START WITH 1000

9 Drop a SEQUENCE

10 Get next value from sequence

11 Get Sequence next value

12 If id is null, use the value from sequence

13 If new value is null use the value from a sequence

14 Random value based on sequence

15 Sequence cache option

16 Sequence current value and next value

17 Sequence max value

18 Set sequence max value

19 Set sequence start value

20 Use dual table to check sequence

21 Use Sequence in a procedure

22 Use sequence in insert command