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
- 14589 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / ravi kumar singh
DECLARE
RETVAL NUMBER:=0;/*A_CHK IS TABLE AND A IS COLOUMN HAVING NOS*/
I NUMBER:=0;
BEGIN
FOR I IN 1..100
LOOP
SELECT COUNT(*) INTO RETVAL FROM A_CHK WHERE A=I;
IF (RETVAL=0) THEN
DBMS_OUTPUT.PUT_LINE(I);
ELSE NULL;
END IF;
END LOOP;
END;
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is meant by cursor in sql?
how would you get the current date in mysql? : Sql dba
What is function and procedure?
How do you bind variables in pl sql?
Mention what does plv msg allows you to do?
What is the difference between python and sql?
What can you do with pl sql?
What does count (*) mean in sql?
What is the difference between mdf and ndf files?
What is trigger in sql and its types?
How to run sql functions in pl/sql?
What is the best free sql database?
Does truncate table reset auto increment?
What is the difference between pl and sql?
What is int identity in sql?
