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
- 16183 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
Explain architecture of sql server notification services?
What is the largest value that can be stored in a byte data field?
What is sql exception?
Which command is used to delete a trigger?
What is the left table in sql?
How do you create a db file?
Is sql microsoft?
What is update query?
What are sql*plus environment variables?
Define commit?
What are data types in pl sql?
Why function is used in sql?
What is the unique index?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the use of primary key?
