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
- 16145 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
What is parallel hint?
How many sql core licenses do I need?
What is cascade in sql?
What are character functions?
Can you select everything, but 1 or 2 fields, without writer's cramp?
When sql appeared?
Why do we use triggers?
Explain about various levels of constraint.
Is sql database free?
How do you add a column to a table?
What does count (*) do in sql?
How to Execute a Package in PL/SQL.?
Explain what is a view?
What are literals in sql server?
What is meaning of <> in sql?
