Sequence in Oracle: Use, Modify, Reset, Drop
What is Sequence in Oracle? Creating a sequence is done using the CREATE SEQUENCE [START WITH] [INCREMENT BY] [NO/MINVALUE] [NO/MAXVALUE] [NO/CYCLE] [NO/CACHE]; Description of each value Examples create sequence test_tech start with 1increment by 1maxvalue 10000cyclecache 20;Orcreate sequence test_tech1start with 1increment by 1maxvalue 4500000cyclenocache; How to use sequences To use sequence simply use the …
Sequence in Oracle: Use, Modify, Reset, Drop Read More »
