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
- 13473 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
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
what is a relationship and what are they? : Sql dba
What is an invalid partition table?
What is sql comments?
What do we need to check in database testing?
What is a primary key called that is made up of more than one field?
What is orm in sql?
Are dml statements autocommit?
Which are the different character-manipulation functions in sql?
Mention what does plv msg allows you to do?
What is schema in sql?
What is cursor and why it is required?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What are the syntax and use of the coalesce function?
Differentiate pl/sql and sql?
