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
-~----------~----~----~----~------~----~------~--~---

Reply via email to