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
- 16214 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 to include numeric values in sql statements? : Sql dba
How to start oracle sql developer?
what is normalization? : Sql dba
How do I start sql from command line?
What does cursor do in sql?
What is oracle sql developer?
What is foreign key and example?
Name the different types of indexes in sql and define them.
What is the use of prepared statement?
what is a stored procedure? : Sql dba
Explain unique key in sql.
what is the different between now() and current_date()? : Sql dba
What does the sign mean in sql?
Can you join a table to itself?
What is the life of an sql statement?
