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
- 16142 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / sumit
declare i number :=1;
begin
a number;
while (i<=100) loop
select num from table into a where num=i;
If a is null then dbms_output.put_line(i);
i:=i+1;
end loop;
end;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many clustered indexes can be created on a table?
What are the benefits of stored procedures?
What is nvl?
Why should I use postgresql?
How do I view a procedure in sql?
How sql query is executed?
What are sql queries used for?
Which are the different types of indexes in sql?
Can variables be used in sql statements?
How does sql*loader handles newline characters in a record? : aql loader
who introduced sql?
Why we use sql profiler?
How do I tune a sql query?
what is the difference between undefined value and null value? : Sql dba
what is a materialized view? : Sql dba
