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
- 16498 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / kavitha n
BEGIN
FOR DATA IN (SELECT LEVEL num
FROM DUAL
CONNECT BY LEVEL <= 100
MINUS
SELECT num
FROM missingsquence)
LOOP
exit when sql%notfound;
DBMS_OUTPUT.put_line (DATA.num);
END LOOP;
END;
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which table is left in join?
What are the advantages of normalization?
Why is a trigger used?
describe transaction-safe table types in mysql : sql dba
What is the usage of the distinct keyword?
How do I restart sql?
How would you convert date into julian date format?
What is sql*loader?
What is Collation Sensitivity ? What are the various type ?
Can you selectively load only those records that you need? : aql loader
what is data integrity? : Sql dba
What are the two types of cursors in pl sql?
How do I truncate a sql log file?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what is an index? : Sql dba
