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
- 15789 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 left join in postgresql?
I need a function for a train ticket reservation please answer it thanks in advance
What is a sql*loader control file?
What is materialized view in sql?
What are different types of indexes?
What are the query optimization techniques?
What are the two parts of design view?
What are the different ddl commands in sql?
How does sql*loader handles newline characters in a record? : aql loader
How to select random rows from a table?
how to create a new view in mysql? : Sql dba
What is database sql?
What is error ora-01000: maximum open cursors exceeded
What are the 3 types of behavioral triggers?
how to analyze tables with 'mysqlcheck'? : Sql dba
