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
- 16509 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 the command line end user interface - mysql? : Sql dba
How do I run a sql query in pgadmin 4?
Can function return multiple values in sql?
What are the types of optimization?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Why trigger is used in sql?
Why do we use joins in sql?
What is mdf ldf and ndf?
What is blind sql injection?
Why is pl sql used?
Is primary key is clustered index?
What is the mutating table and constraining table?
What are inner and outer joins examples of both?
Mention what is the use of function "module procedure" in pl/sql?
Explain the savepoint statement.
