create dynamic groups like; ABC, BCA, CAB, CBA...
I have two columns like, treatcode and groups
If treatcode is 2 (A,B) then groups column should be
If treatcode is 3 (A,B,C) then groups column shoud be
If treatcode is 4 (A,B,C,D) then groups column shoud be
Whenever the treatcode increases the groups should be increase.
Please let me know is there any good approach for this?
Yes, write a PL/SQL function.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Click Here to Expand Forum to Full Width