Re: substr instr
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 29 Jul 2009 08:12:33 -0500 (CDT)
Message-ID: <e00e21e6896acbca9e5522535934adf1.squirrel_at_society.servebeer.com>
> I think this should do nicely
>
> select regexp_replace('Start net counter : 203542, 201282','^.+:
> *([0-9]+),.*$','\1')
> from dual;
>
> Cheers,
> Flado
Date: Wed, 29 Jul 2009 08:12:33 -0500 (CDT)
Message-ID: <e00e21e6896acbca9e5522535934adf1.squirrel_at_society.servebeer.com>
> 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-lReceived on Wed Jul 29 2009 - 08:12:33 CDT