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

"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