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
- 16187 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
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
Why we use triggers in mysql?
What is cursor in pl sql?
What is a table?
What is view? Can we update view
What is t sql used for?
How do I make sql search faster?
What is group by in sql?
Is ms sql is free?
What is sql and explain its components?
how many ways to get the current time? : Sql dba
What is oracle sql called?
How do you write an inner join query?
Why use triggers in sql?
When to use inner join and left join?
What do you understand by pl/sql cursors?
