Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: String manipulations

Re: String manipulations

From: <sybrandb_at_hccnet.nl>
Date: Wed, 28 Mar 2007 00:05:37 +0200
Message-ID: <275j03hqnqp35oofdqo4skkcf2kufpo598@4ax.com>


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 DBA
Received on Tue Mar 27 2007 - 17:05:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US