SQL & PL/SQL

Hi ,

I have the following string

select '1, ,3, , , abc, ,dce,234, , , abc 1 ,1 ,4 ' from dual

and i have translations for

abc,dce and abc 1 respecitvely as
X ,Y and Z

which i strore in a table as

1 abc X
2 dce Y
3 abc 1 Z

now i want to replace these tranlations in my original string such that my spaces etc are intact ( note that i cannot use the replace function directly)

MY final string should look like

1, ,3, , , X, ,Y,234, , , Z ,1 ,4

any pointers how i can achieve it.



Thanks