DECLARE l_id NUMBER;/* Temp IS TABLE AND ID IS COLOUMN HAVING Nu

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 / mani

9 Answers
16049 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / mani

DECLARE

l_id NUMBER;/* Temp IS TABLE AND ID IS COLOUMN HAVING
Numbers*/

BEGIN

FOR I IN 1..100 LOOP
SELECT COUNT(*) INTO l_id FROM temp WHERE id=I;
IF (l_id = 0) THEN
DBMS_OUTPUT.PUT_LINE(I);
ELSE
NULL;
END IF;
END LOOP;

END;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe different types of general function used in sql?

1016

What is the use of triggers?

1022

Explain how to use transactions efficiently : transact sql

955

Is primary key always clustered index?

993

Can you do multiple joins in sql?

1022

What is the difference between rename and alias?

1326

How many types of cursors are available in pl/sql?

1082

How to load data with sql*loader?

1033

What is on delete restrict?

988

What is a schema sql?

1126

What are the disadvantages of not performing database normalization?

1145

What are the types of dbms?

955

What is coalesce sql?

977

What are system versioned tables?

1010

What is sql architecture?

1034