SQL> desc numtab; Name Null? Type ------ -------

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?

Question Posted / subrat ray

9 Answers
16484 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

Please Help Members By Posting Answers For Below Questions

What is auto increment?

1044

what is a join? : Sql dba

1083

What is dcl in sql?

1024

Define implicit and explicit cursors.

1205

Is sqlexception checked or unchecked?

1008

Can we alter stored procedure?

1042

Describe types of sql statements?

1102

Explain what is a subquery ?

1242

how to drop an existing table in mysql? : Sql dba

1088

Is sql database free?

1024

How do I view stored procedures?

1022

What is the trigger in sql?

1001

What are the advantages of normalization?

1127

Is sql a backend?

1070

Which table is left in left join?

1060