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
- 16050 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
Why use truncate instead of delete?
Write a query to find the names of users that begin with "um" in sql?
What is primary key and foreign key?
How do I view a sql trace file?
What is the difference among union, minus and intersect?
What is constant in pl sql?
what is acid property in database? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is the benefit of foreign key?
What is meant by <> in sql?
What is data abstraction in sql?
Show the two pl/sql cursor exceptions.
What is #table in sql?
What is file based approach?
What is package in pl sql with an examples?
