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
- 15774 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 where clause in sql?
Are pl sql variables case sensitive?
What does an inner join do?
How does sql developer connect to oracle database?
what is the different between now() and current_date()? : Sql dba
What are the types of subqueries?
Does access use sql?
Why do we create views in sql?
Explain correlated query work?
What does := mean in pl sql?
What are primary key and foreign key and how they work?
Why having clause is used in sql?
What is posting?
How many sql core licenses do I need?
What is embedded sql with example?
