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
16520 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 out parameter used for eventhough return statement can also be used in pl/sql?

1128

what is a database lock ? : Sql dba

1227

How do I quit sql?

1009

What is where clause in sql?

1088

What is the use of nvl function?

1246

What are the types of keys?

1067

How many types of privileges are available in sql?

1409

What is the purpose of design view?

1078

What are the triggers associated with image items?

1093

What is posting?

1086

What is case function?

1094

what are the different type of sql's statements ? : Sql dba

982

List the various privileges that a user can grant to another user?

1098

What version is sql?

1078

How can we solve sql error: ora-00904: invalid identifier?

1295