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
- 16134 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
Why is partition used in sql?
How to get unique records from a table?
how can you create an empty table from an existing table? : Sql dba
How many types of functions are there in sql?
Is it possible to pass parameters to triggers?
How bulk collect improves performance?
What is memory optimized table?
What is the difference between python and sql?
what is sub-query? : Transact sql
What are the different types of constraints?
What is union?
What is oracle pl sql developer?
What are the different schemas objects that can be created using pl/sql?
What is left join in postgresql?
Why are sql stored procedures used?
