Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: String manipulations
On 27 Mar 2007 12:10:04 -0700, "nirav" <shivam71_at_gmail.com> wrote:
>>
>> To add one more details: the fourth row could be:
>> Mohan (x,m,z) went to see Joe
>>
>> & so basically the three parameters inside the braces are all variable
>> length varchar strings and in this example, it should change to:
>> Mohan (x,m,'~'z) went to see Joe
>>
>One more detail: I am not on Oracle 10g, so can not use regular
>expression..Oracle version :9.2.0.7.
>
In the time you post all this so-called 'detail', you could already have resolved it using instr, and substr. But alas, you rather want others to do your work. What if the internet broke down in your locale?
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Mar 27 2007 - 17:05:37 CDT