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
- 15769 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 the use of sqlerrd 3?
How do you respond to dementia behavior?
Can a table contain multiple primary key’s?
What is primary key and unique key?
Do ddl statements need commit?
What is pl sql script?
How to Execute a Package in PL/SQL.?
Explain what is sql*plus?
What is rank function in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What are the possible values that can be stored in a boolean data field?
Why do we need cursors in pl sql?
What is trigger types in sql?
how does a local variable is defined using t-sql? : Transact sql
How do you delete data from a table?
