Part32 sequence using auto primary key
Download as PPTX, PDF
0 likes210 views
The document describes creating a sequence called seqgirija in Oracle that starts at 1000 and increments by 1 without cycling or caching. A table called girija is then created with a primary key column called flowerid that uses the seqgirija sequence to automatically populate integer IDs. Three records are then inserted into the girija table to demonstrate the auto-incrementing primary keys from the sequence.
Convert to study materialsBETA
Transform any presentation into ready-made study materialselect from outputs like summaries, definitions, and practice questions.
Part32 sequence using auto primary key
- 1. Dr. Girija Narasimhan Part 32 sequence using auto primary key
- 2. Dr. Girija Narasimhan SQL> create sequence seqgirija 2 start with 1000 3 increment by 1 4 nocycle 5 nocache; Sequence created. SQL> create table girija(flowerid number(6) primary key,fname varchar2(25)); Table created.
- 4. Dr. Girija Narasimhan SQL> select * from girija; FLOWERID FNAME ---------- ------------------------- 1000 lotus 1001 sunflower 1002 jasmine