select level from dual connect by level<=(select max(seq_no) from test

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 / dipanshu saini

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

Answer Posted / dipanshu saini

select level from dual connect by level<=(select max(seq_no) from test_tab)
minus
select seq_no from test_tab;

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 the difference between unique and primary key constraints?

1007

Can we use pl sql in mysql?

960

How do I upgrade sql?

947

What is sql performance tuning?

867

What is sql partition?

1036

How do you remove duplicates without using distinct in sql?

919

How delete a row in sql?

926

Can sql developer connect to db2?

985

how to escape special characters in sql statements? : Sql dba

967

How many sql statements are used? Define them.

981

What is multiple partition?

920

What does partition by mean in sql?

908

Explain cursor types?

955

What packages are available to pl/sql developers?

992

What are the types of operators available in sql?

1009