Re: REGEXP_SUBSTR() is always NULL

>> 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
>> --

As David already suggested, perl influenced extensions came in 10.2, the list is at
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_posix003.htm

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

Best regards

Maxim

-- 
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ørgensen