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: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 3 Nov 2004 06:18:11 +0100
Message-ID: <41886a3a$0$32238$636a15ce@news.free.fr>

"Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> a écrit dans le message de news:ea01504d.0411021920.3a57d1b9_at_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

Maybe it is a little help to post your error/spool. (and maybe it is a little help to switch on brain.)

SQL> create table t (col1 number);

Table created.

SQL> insert into t values (7);

1 row created.

SQL> insert into t values (8);

1 row created.

SQL> commit;

Commit complete.

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

       SEQ


         1
         2
         3
         4
         5
         6

6 rows selected.

-- 
Regards
Michel Cadot
Received on Tue Nov 02 2004 - 23:18:11 CST

Original text of this message

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