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
- 16217 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 the source code of a program?
What makes a good primary key?
What is embedded sql what are its advantages?
What are the advantages of sql?
Is drop table faster than truncate?
What is nvl?
Write an sql query to select all records from the table?
What is difference between stored procedures and application procedures?
What are procedures used for?
Why we use joins in sql?
What is the difference between delete and truncate statement in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
how to get a list of columns in an existing table? : Sql dba
What are the basic sql commands?
What is sequence in sql?
