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 / neha sinha
create or replace procedure pro1(cur_diff OUT SYS_REFCURSOR) is
BEGIN
OPEN cur_diff FOR
select diff
from (select /*+ no_merge */
rownum as diff
from (select 1 from dual group by cube(1, 1,
1, 1, 1)) a,
(select 1 from dual group by cube(1, 1,
1, 1, 1, 1)) b)
where diff >= (select min(lst) from list1)
and diff <= (select max(lst) from list1)
minus
select lst from list1;
end pro1;
-- where list1 is table name and lst is column in which
--some no is missing
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure in sql with example?
What is sql used for?
What is a database trigger?
What are local and global variables and their differences?
What are stuff and replace function?
How to look at the current sql*plus system settings?
Is it possible to create startup or shutdown trigger for on-schema?
what is schema? : Sql dba
what is the difference between char and varchar data types? : Sql dba
What are analytical functions in sql?
How to revise and re-run the last sql command?
what is sql? : Sql dba
Why join is faster than subquery?
What is bind reference and how can it be created?
What is a file delimiter?