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!
my column values are 1A,1B, 2A ,2B need to be update like these 1CA-A, 1CA-B, 2CA-A, 2CA-B all A should replace to CA-A and B to CA-B
another column value is 1A, 2A should replace to 1S, 2S all A should replace to S
please help with update query