Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16172 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
What is data profiling in sql?
What do you understand by exception handling in pl/sql?
Can we use having without group by in sql?
What are the two types of exceptions.
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Why do we go for stored procedures?
Can we use ddl statements in stored procedure?
How do I remove sql developer from windows 10?
Explain the uses of control file.
What is record type in pl sql?
what are the authentication modes in sql server? : Sql dba
How can I speed up sql query?
How can use stored procedures in sql?
What is over () in sql?
What are basic techniques of indexing?
