SELECT SUBSTR (mystr, 1, INSTR (mystr, ',')) || 'Emptybasket' FROM (SELECT 'Shoppingtrolley,Shoppingbasket' mystr FROM DUAL);
On Tue, Oct 14, 2008 at 7:40 AM, Vlad <[EMAIL PROTECTED]> wrote: > > I need to replace the second occurrence of one string within another:- > > E.g. > > 'Shoppingtrolley,Shoppingbasket' > > needs to be come > > 'Shoppingtrolley,Emptybasket' > > Any ideas? > > TIA > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---