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
- 14590 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
Why is sharding used?
What is a unique key and primary key and foreign key?
How do you optimize a stored procedure in sql?
How can you load microsoft excel data into oracle? : aql loader
What is rename in sql?
What is the use of triggers?
What is set transaction?
What is a temp table?
Will truncate release space?
Which command is used to delete a package?
What is posting?
What is pivot query?
what is dbms? : Sql dba
What are few of the schema objects that are created using PL/SQL?
Does sql support programming?
