Re: substr instr

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 29 Jul 2009 17:11:27 +0100
Message-ID: <7765c8970907290911k3b5e5b81i602f2a84f77df720_at_mail.gmail.com>

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_at_society.servebeer.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 29 2009 - 11:11:27 CDT