Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

skip the for loop

user-xzs5cAug 11 2023 — edited Aug 11 2023

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?

Comments