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
16485 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

Is and as keyword in pl sql?

1011

What is set serveroutput on?

1177

What is natural join in sql?

1044

What is a loop in sql?

1034

Does db2 use sql?

1009

How do you delete data from a table?

1097

What is primary key in db?

1067

How to rename a column in the output of sql query?

1123

What is insert command in sql?

1186

What is query syntax?

1018

Is trigger a stored procedure?

980

How to add, remove, modify users using sql?

1088

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

How does one use sql*loader to load images, sound clips and documents? : aql loader

1233

What is the largest value that can be stored in a byte data field?

1057