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

Does inner join remove duplicates?

936

how to add a new column to an existing table in mysql? : Sql dba

1064

Is sql a backend?

1012

Can we perform dml on view?

1040

How do I count rows in sql?

997

what are the difference between clustered and a non-clustered index? : Sql dba

1030

What are all the ddl commands?

1177

How do I partition a table in sql?

1124

how to run 'mysql' commands from a batch file? : Sql dba

1110

Can we write ddl statements in functions?

1111

Define tables and fields in a database

1126

How do I enable sql encryption?

1023

How can you know that statistics should be updated?

1075

Explain two easy sql optimizations.

1008

Explain the significance of the & and && operators in pl sql.

1005