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
- 16175 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 pl sql variable?
What is the purpose of using pl/sql?
what is try_catch block in procedure
What are the different sql commands?
Enlist the advantages of sql.
What is thread join () in threading?
What is cross join sql?
What are the types of records?
What is difference between sql and excel?
Give the order of sql select?
what is the functionality of the function htmlentities? : Sql dba
How do I clear the screen in sql plus?
How to select random rows from a table?
How many postgresql users are there, worldwide?
What do you understand by pl/sql packages?
