Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to retrive Deleted Sequence Number????

Re: How to retrive Deleted Sequence Number????

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 2 Nov 2004 19:20:33 -0800
Message-ID: <ea01504d.0411021920.3a57d1b9@posting.google.com> 





I have Tried this query but giving error



select a.seq


from (select rownum seq from dual group by cube(1,2,3)) a
where not exists (select 1 from sampleTable t where t.col1 = a.seq)
/


Regards


Arijit Chatterjee
Received on Tue Nov 02 2004 - 21:20:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US