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
- 15763 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
How do I edit a stored procedure?
Differentiate between pl/sql and sql?
What is localdb mssqllocaldb?
How many types of keys are there in sql?
Explain isolation levels. : Transact sql
what does myisamchk do? : Sql dba
What are the types of functions in sql?
What are the parameter modes supported by pl/sql?
How do I add a database to sql?
How do I create a sql database?
What are the features of pl sql?
What are the parts of a basic sql query?
What is sql trigger example?
what is the difference between delete and truncate commands? : Sql dba
How can we make an if statement within a select statement?
