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
- 14596 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
How many joins can you have in sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
what are the difference between clustered and a non-clustered index? : Sql dba
Can we insert in view in sql?
How do I run pl sql in sql developer?
Difference between truncate, delete and drop commands?
Why do we need unique key in a table?
what is myisam? : Sql dba
List out the acid properties and explain?
What is foreign key sql?
How many clustered indexes can you have?
What version is sql?
What is the difference between python and sql?
what are the security recommendations while using mysql? : Sql dba
How does rowid help in running a query faster?
