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!

Distinct combinations across multiple columns

User_FGZFHDec 22 2020

Hi Experts,

I have a requirement to convert the following source data into combinations of the column 'Category_id', but the combination should not belong to the same categorization_id.
Ex. combination (1, 4, 6) is valid, but combination (1, 2, 5) is not valid as 1 and 2 belong to the same categorization.
the below target:

This post has been answered by mathguy on Dec 22 2020

Jump to Answer

Added on Dec 22 2020

4 comments

2,223 views

1 mention