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
- 14598 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
Where the sql database files are stored?
How do you modify a table in sql?
What is the difference between a database and a relational database?
Is primary key an index?
What is pl sql in dbms?
What are the advantages of sql? Explain
What is a sql*loader control file?
what are the different type of normalization? : Sql dba
What is pl sql architecture?
Can triggers stop a dml statement from executing on a table?
How many functions are there in sql?
What does t sql mean?
how to include numeric values in sql statements? : Sql dba
What is the size of partition table?
Can you selectively load only those records that you need? : aql loader
