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
- 16143 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 are the different tcl commands in sql?
How many triggers can be applied to a table?
what does it mean to have quoted_identifier on? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are all ddl commands?
What is scalar data type in pl sql?
What is crud sql?
What are packages in pl sql and also explain its advantages?
What is difference between mysql and postgresql?
What is application trigger?
what are local and global variables and their differences? : Sql dba
how to create a new view in mysql? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
What is normalisation in sql?
What are the two characteristics of a primary key?
