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
- 16140 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 nvl?
Explain dml and ddl?
When is the update_statistics command used?
What is a recursive join sql?
What are pl sql procedures?
Which type of cursor is used to execute the dml statement?
What is a natural join sql?
What is triggering circuit?
How to get list of all tables from a database?
How can we avoid duplicating records in a query?
How do I find duplicates in a single column in sql?
What are the two types of periodical indexes?
When are we going to use truncate and delete?
What is normalization? How many normalization forms are there?
How is indexing done in search engines?
