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?



January 01, 2006 01:34:42 #4
 pankaj_gauba   Member Since: November 2005    Total Comments: 14 

RE: what is a sequence?
 

All defination of sequence is correct given by all but the sequence has it's limitation.

1.Once the number skips ,it cannot be recovered.

2.u can use the same sequence with any table.

e.g select seq1.nextval from emp; select seq1.nextval from dept.

so the number once skiped cannot be recovered.

     

 

Back To Question