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
- 16051 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / sureshramsing@gmail.com
select level from dual connect by level<=100 minus select <column name> from <table name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is duration in sql profiler trace?
What is pl sql script?
what is data manipulation language? : Sql dba
How to run sql statements through the web interface?
What is the difference between sql, mysql and sql server?
Is it possible to create the following trigger: before or after update trigger for each row?
what is recursive stored procedure? : Sql dba
How do you create a unique index?
What is insert command in sql?
Explain constraints in sql?
Is and as keyword in pl sql?
Can sql developer connect to db2?
Can we use the cursor's to create the collection in PL/SQL?
What are two statement types in sql?
Explain mutating table error.
