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?
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
How does join work in sql?
What is difference between mysql and postgresql?
Differentiate between syntax and runtime errors.
what is the difference between primary key and unique key? : Sql dba
What is meant by <> in sql?
How will you distinguish a global variable with a local variable in pl/sql?
What is an inconsistent dependency?
What is $$ in sql?
Why stored procedure is faster than query?
how to drop an existing index in mysql? : Sql dba
How do I view output in sql developer?
Explain the update statement in sql
What is difference between stored procedure and trigger?
What is pl sql code?
how to include comments in sql statements? : Sql dba