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
- 16483 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
What is group by in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do you identify a primary key?
what is the difference between char_length and length? : Sql dba
How do you bind variables in pl sql?
How to fetch alternate records from a table?
What is a temp table?
what are date and time data types? : Sql dba
What is union, minus and interact commands?
Does oracle use sql?
How do I run a pl sql program?
What is rownum and rowid?
write an sql query to find names of employee start with 'a'? : Sql dba
how to fetch common records from two tables? : Sql dba
What is sql scripting?
