Skip to Main Content

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!

Data validation in a table based on values on another table

939393Sep 8 2020 — edited Sep 8 2020

Hi All,

Scenerio is i have a table say A loaded with millions of data. My manager told me to do data validation on table A and add 2 seprate column in table A which shows Validation succeed when LOV in table A matches with LOV in table B. How to do that previously i am using regexp_like to validate the data but my manager told me to not hardcore the script but validata the data when that values are there in table b.

Any help will bi highly appreciate.

     Thanks in advance

Comments
Post Details
Added on Sep 8 2020
7 comments
1,655 views