Re: REGEXP_SUBSTR() is always NULL
Date: Thu, 25 Jun 2009 20:05:17 +0200
> On Jun 25, 6:52 am, "Álvaro G. Vicario"
> <alvaro.NOSPAMTH..._at_demogracia.com> wrote:
>> ddf escribió: >> >>> On Jun 25, 6:29 am, "Álvaro G. Vicario" >>> <alvaro.NOSPAMTH..._at_demogracia.com> wrote: >>>> In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server, >>>> REGEXP_SUBSTR() always returns NULL. E.g.: >>>> SELECT REGEXP_SUBSTR('1234,5678', '\d+', 1, 1) >>>> FROM DUAL >>>> In my local 10g XE, however, it returns 1234 as expected. >>>> Is it me or is it the server? >>> It may be the server if you are, indeed, comparing XE (10.2.0.1) to a >>> 10.1.0.2 release. You're certain you've posted the version for the >>> Enterprise Edition correctly? >> Absolutely: SELECT BANNER FROM v$version + clipboard. >> >> If it was a legacy edition that did not support REGEXP_SUBSTR() I'd >> expect an error message. >> >> Is it possible to cancel, disabled or override REGEXP_SUBSTR? >> >> -- >> --http://alvaro.es- Álvaro G. Vicario - Burgos, Spain >> -- Mi sitio sobre programación web:http://borrame.com >> -- Mi web de humor satinado:http://www.demogracia.com >> --
> Things have changed between 10.1 and 10.2:
> 10;1 regular expression support --
> 10.2 regular expression support --
> These differences may result in the differences you're seeing.
> David Fitzjarrell
As David already suggested, perl influenced extensions came in 10.2, the
list is at
On 10.1 one should use instead the posix syntax REGEXP_SUBSTR('1234,5678', '[[:digit:]]+', 1, 1) or REGEXP_SUBSTR('1234,5678', '[0-9]+', 1, 1) or
-- Why make things difficult, when it is possible to make them cryptic and totally illogical, with just a little bit more effort? Aksel Peter JørgensenReceived on Thu Jun 25 2009 - 13:05:17 CDT