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
- 16030 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 does one use sql*loader to load images, sound clips and documents? : aql loader
What is the benefit of foreign key?
What is the function that is used to transfer a pl/sql table log to a database table?
What is the difference between execution of triggers and stored procedures?
What is oracle sql called?
Difference between truncate, delete and drop commands?
How do I create a sql script?
What is set serveroutput on?
How do I start sql from command line?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How can we make an if statement within a select statement?
What are different categories of sql commands?
what are the 'mysql' command line arguments? : Sql dba
Can you selectively load only those records that you need? : aql loader
How do I remove duplicates in two columns?
