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
- 16144 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / vishnu
create table test100 (id number);
insert into test100
select level from dual connect by level <=100;
select id from (SELECT rownum id from test100) where id
not in (select ID from(select rownum,id from test100) where id!=decode(id,rownum,rownum+1,rownum));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is flag in sql?
tell me about various levels of constraint. : Sql dba
What is use of trigger?
Why we use pl sql?
What are the disadvantages of file system?
What are the different type of joins in sql?
How do you run a query?
What is cost in sql execution plan?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Which sorts rows in sql?
What are expressions?
What is the primary use of normalization?
What is column?
What does pragma mean?
How can a pl sql block be executed?
