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
- 16025 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / subrat ray
SQL> desc numtab;
Name Null? Type
------ ------- ------
X NUMBER(4)
declare
v_num number(2);
cursor c1 is select rownum num from all_tables where rownum<=100
minus
select x num from numtab;
begin
open c1;
loop
fetch c1 into v_num;
exit when c1%notfound;
dbms_output.put_line(v_num);
end loop;
close c1;
end;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is Materialized View? In What Scenario we Use Materialized View?
What is sql*loader?
What is nvl?
What is difference between pl and sql?
Is clustered index a primary key?
What is server name sql?
what is clause? : Sql dba
Can we delete column in sql?
what are all different types of collation sensitivity? : Sql dba
What is the starting oracle error number?
Are left and right joins the same?
What is sqlerrm?
How do I run a sql script?
how many values can the set function of mysql take? : Sql dba
How many row comparison operators are used while working with a subquery?
