TABLE A
ID
1
2
3
4
TABLE B
ID
1
2
3
5
FOR LOOP ---loop 1-- table A
FOR LOOP ---loop 2 – TABLE B
IF A.ID=B.ID
--DBMS\_OUTPUT\_PUT\_LINE('BOTH MATCHING')
ELSE
--DBMS\_OUTPUT\_PUT\_LINE('NOT MATCHING')
END IF;
END LOOP;
END LOOP;
here shows incorrect out put above query. we need skip this loop2 if both id same, then go to loop 1.
here compare data again and again I have used contiune and exit. but did not work correctly.
any suggestions?