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
- 16030 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 dcl in sql?
which tcp/ip port does sql server run on? : Sql dba
How many types of cursors supported in pl/sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Why is sql better than hql?
How would you pass hints to the sql processor?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Where do we use pl sql?
Is sql between inclusive?
what is the difference between union and union all? : Sql dba
Which normal form is best?
What is sql architecture?
Is sql open source?
Explain exception handling in pl/sql?
What is java sql driver?
