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?
- 9 Answers
- 14597 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
how to delete an existing column in a table? : Sql dba
What steps server process has to take to execute an update statement?
Can you have more than one key in a database?
How do I find sql profiler?
What are the different types of tables in sql?
What is sqlite format?
Do we need to rebuild index after truncate?
How does sql store data?
what is a database? : Sql dba
What is difference between sql function and stored procedure?
how to write date and time literals? : Sql dba
What does varchar include?
Is primary key an index?
What is parameter substitution in sql?
What is the difference between instead of trigger and after trigger?
