create table test100 (id number); insert into test100 select level from

If there are 1 to 100 numbers in a table and in that 100
numbers some 10 numbers are deleted.I want to find out the
missing numbers between 1 to 100 by pl/sql how?

Question Posted / vishnu

9 Answers
16171 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / vishnu

create table test100 (id number);

insert into test100
select level from dual connect by level <=100;

select id from (SELECT rownum id from test100) where id
not in (select ID from(select rownum,id from test100) where id!=decode(id,rownum,rownum+1,rownum));

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql dialect?

1115

What does closing a cursor do?

1320

What is trigger price?

986

How can I make sql query run faster?

1015

What is secondary key?

933

Can you rollback after commit?

982

What is a system versioned table?

982

What are the different type of joins in sql?

954

Why do we need a foreign key?

1093

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1156

what is collation? : Sql dba

1148

What is orm in sql?

1046

Does pl sql work in mysql?

980

What is the meaning of disabling a trigger?

1182

How do you exit in sql?

1106