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
- 16521 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 flag in sql?
What is bulk compiling in pl/sql.?
Can %notfound return null after a fetch?
What are the disadvantages of not performing database normalization?
How is pl sql different from sql?
what are the features and advantages of object-oriented programming? : Sql dba
What makes a good primary key?
What are the basic sql commands?
What are sql functions? Describe in brief different types of sql functions?
What is a file delimiter?
How do you respond to dementia behavior?
What are the types of dbms?
Mention what is the plv (pl/vision) package offers?
What is the difference between cluster and non-cluster index?
What is the difference between join and natural join?
