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
- 16507 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
Why do we use view in sql?
what is 'mysqld'? : Sql dba
How do I run pl sql in sql developer?
What is varchar data type in sql?
How many developers work on postgresql?
List out the acid properties and explain?
What are different types of queries in sql?
what is a composite primary key ? : Sql dba
Is oracel sql developer written in java?
what happens if you no create privilege in a database? : Sql dba
Why we use triggers in mysql?
How do you declare a variable in pl sql?
Are left and right joins the same?
Can we use two order by clause in query?
what are all the different normalizations? : Sql dba
