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
- 16043 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
what are all different types of collation sensitivity? : Sql dba
What do you understand by exception handling in pl/sql?
What is difference between stored procedure and trigger?
What is flag in sql?
How many sql commands are there?
How delete all data from table in sql?
what are sequences
Define commit?
What is the reports view in oracle sql developer?
What is application trigger?
how to convert character strings to dates? : Sql dba
Which command is used to delete a package?
How do I partition in sql?
Explain ttitle and btitle.
Differentiate pl/sql and sql?
