Re: REGEXP_SUBSTR() is always NULL
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Thu, 25 Jun 2009 13:52:52 +0200
Message-ID: <h1voil$lmh$1_at_news.eternal-september.org>
ddf escribió:
>> 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?
Date: Thu, 25 Jun 2009 13:52:52 +0200
Message-ID: <h1voil$lmh$1_at_news.eternal-september.org>
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 --Received on Thu Jun 25 2009 - 06:52:52 CDT