Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table Product_group, which contain 2 column
Product Product_2
SPOT SPOT-T
FIX ---------
TOM ----------
SPOT SPOT-T1
SPOT SPOT-T2
i need to add third column DETAILED_PRODUCT which should look as below
DETAILED_PRODUCT
SPOT-T
FIX
TOM
SPOT-T1
SPOT-T2
where SPOT need to split in third column like where ever SPOT in Product column should be replace by Product_2.
Please help me with this. thank you