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
- 16188 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 do you take the union of two tables in sql?
what are integrity rules?
How do you delete data from a table?
Why having clause is used in sql?
Can we commit inside a trigger?
Which is faster view or stored procedure?
What does trigger mean in psychology?
What are the types of queries in sql?
What is a rank in sql?
give the syntax of grant and revoke commands? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is the sql*loader? : aql loader
What is the difference between the conventional and direct path loads? : aql loader
What is the mutating table and constraining table?
