SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to check if a value exists in a table..

660427Sep 18 2008 — edited Sep 18 2008

i have to do something like

IF item_stg_row(i).divdesc exists in division table) THEN
l_set_status := 0;
l_reason := 'does not exist in Division Table';
END IF;

thing is though i do have a solution of this by saving the values of the table into an array using cursor and then checking thru "Member OF" ... it takes a lots of code lines...I have to repeat this process these steps for 7 more tables and its just pretty long method...

Is there a simpler solution ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2008

Added on Sep 18 2008

#oracle, #plsql, #sql, #table

6 comments

5,135 views