Re: substr instr
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
- Date: Wed, 29 Jul 2009 17:11:27 +0100
OWA_PATTERN should do the job in that version, although it may not be
installed and *will* have performance issues for large amounts of data.
Niall
On 7/29/09, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > I think this should do nicely
> >
> > select regexp_replace('Start net counter : 203542, 201282','^.+:
> > *([0-9]+),.*$','\1')
> > from dual;
> >
> > Cheers,
> > Flado
>
> But not in v9 that the OP's using...
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts: