HI Team
I have two tables in oracle database, details mentioned below:
Tabl1 - Col1, Col2, Col3 ( all are varchar2(4000).
Tabl2 - Col1, Col2, Col3 ( all are varchar2(4000).
The content of Tab1.col2 is a comma separated string. say for e.g. A,B,C,D.
Similarly, The content of Tab2.col3 is a comma separated string. say for e.g. D,B,A,C.
My requirement is-
To loop through each and every record of Tab1 and find a matching value in Tab2. col3.
The order of the occurrences of text is immaterial. Say for e.g. E,F,G will be considered a match with F, G, E.
However E,F,G will not be considered a match for F,E,G,K (.i.e. any extra text if present in the target table, will not be considered as match)
Appreciate a code snippet in this regard,
Thanks