Re: pl/sql - pattern matching / regular expressions

From: Christopher Latta <nobody_at_nowhere.not>
Date: Mon, 11 Jun 2001 23:20:14 +1000
Message-ID: <4G3V6.3048$qJ4.130781@ozemail.com.au>

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 Mon Jun 11 2001 - 08:20:14 CDT