Oracle PLSQL Tutorial Sequences 28 codes

1 Altering an existing sequence

2 Automatically including unique sequence numbers during an INSERT

3 Create a sequence

4 Create a sequence starting with 1000

5 Create a sequence starting with 100000000 order

6 Create sequence deptno_seq start with 50 increment by 10

7 Create sequence emps_seq start with 501 increment by 10

8 CREATE SEQUENCE myTableIDSeq INCREMENT BY 1 START WITH 1000

9 CREATE SEQUENCE test_seq

10 Create the simplest sequence

11 Creating a sequence and then get the next value

12 Dropping a Sequence

13 Get next value from sequence

14 Get Sequence information from user_sequences table

15 Getting Information on Sequences

16 If id is null, use the value from sequence

17 Modifying a Sequence

18 Once initialized, you can get the current value from the sequence using currval

19 Populating a Primary Key Using a Sequence

20 Query current sequence value

21 Random value based on sequence

22 Select deptno_seq currval, deptno_seq nextval

23 Sequences

24 Set start value, minimax value and cache

25 Test sequence step

26 Use dual table to check sequence

27 Using a sequence to populate a tables column

28 When you select currval , nextval remains unchanged; nextval only changes when you select nextval to get the next value