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?
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 difference between group by and partition by?
Could you please provide oca (oracle 10g) dumps for my certification ?
Can you skip header records while loading? : aql loader
What is sql in java?
How do I run sql profiler?
Does truncate need commit?
How do you write a complex sql query?
What if we write return in procedure?
What is multiple columns?
How do I find sql profiler?
How do you respond to dementia behavior?
What is the limitation on the block size of pl/sql?
What is a primary key sql?
What does trigger mean in psychology?
what are the different index configurations a table can have? : Sql dba