GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
Question:  what is a sequence?



November 11, 2005 05:26:29 #3
 vardhan_81   Member Since: November 2005    Total Comments: 4 

RE: what is a sequence?
 

Sequence is a Database object used to generate unique sequential integer values. the syntax is

CREATE SEQUENCE <SEQUENCENAME>

START WITH <INT>

MIN VALUE/NOMINVALUE<INT>

MAXVALUE/NOMAXVALUE<INT>

INCREMENT BY

CYCLE/NOCYCLE

CACHE/NOCACHE;

EX:CREATE SEQUENCE SEQ1

                                        INCREMENT BY 1

                                        START WITH 1

                                        MINVALUE 0

                                        NOCYCLE

                                        NOCACHE

                                        NOORDER;

     

 

Back To Question