Hi Guys, There is a table which contains tow columns.
Table -->Mapping Col1 | Col2 ------------------------------------------------------------- 1121-F-102 | 1123!F!101 | [EMAIL PROTECTED]@145 | 1145#R#190 | In another table i will have one column Table --> Punctuation Col1 ------- - ! @ I need to write a procedure that will take the values from Punctuation table and replace those characters in the mapping table Col1 and insert it into Col2 table. But here if i fetch first record from punctuation table and replace them into mapping there will be only one record in Col2. So next level of replacement should happen on Col1. But the problem is records to replace will not be in the ordered form. Other problem exists when there is combination of punctuations in the Col1 of mapping table. Regards, Swapna --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
