Re: substr instr
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.
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...
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 29 2009 - 11:11:27 CDT