Re: pl/sql - pattern matching / regular expressions

OK, thanks for that.

however, I require the pattern to be identified as '[*|*]' and then the stuff done - can patterns be matched in this way (where * is used as a wildcard)?

In article <4G3V6.3048$qJ4.130781_at_ozemail.com.au>, Christopher Latta says...
>
>You can do this using the substr and instr functions:
>
>select
>substr('[www.oracle.com|go to oracle]', 1, instr ('[www.oracle.com|go to
>oracle]', '|')-1)
>from dual
>
>HTH,
>Christopher Latta
>
>knight <nospam_at_newsranger.com> wrote in message
>news:TH0V6.3534$pb1.130551_at_www.newsranger.com...
>> I am trying to match a specific line in my data and as a beginner am
 wondering
>> how to do this.
>>
>> The pattern to match would be eg:
>>
>> [www.oracle.com|go to oracle]
>>
>> With this info matched I would then like to split this info on the '|'
>>
>> Can be done with Perl - but how with pl/sql?
>
>
>
Received on Sat Jul 21 2001 - 16:22:12 CDT