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
- 16030 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 the left table in sql?
How do you write an inner join query?
What is bulk collect in pl sql?
What is on delete restrict?
What is join view in sql?
What is sql injection owasp?
Is sql difficult?
Explain architecture of sql server notification services?
what is self-join? : Sql dba
Can we insert data into materialized view?
How to display the records between two range in Oracle SQL Plus?
What is parallel hint?
How do I start pl sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What are the disadvantages of not performing database normalization?
