Re: REGEXP_SUBSTR() is always NULL
From: ddf <oratune_at_msn.com>
Date: Thu, 25 Jun 2009 04:40:04 -0700 (PDT)
Message-ID: <9030ab2d-3ca2-4315-a0f1-ce06c0128b32_at_o36g2000vbi.googlegroups.com>
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?
>
> --
> --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
> --
Date: Thu, 25 Jun 2009 04:40:04 -0700 (PDT)
Message-ID: <9030ab2d-3ca2-4315-a0f1-ce06c0128b32_at_o36g2000vbi.googlegroups.com>
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?
>
> --
> --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
> --
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?
David Fitzjarrell Received on Thu Jun 25 2009 - 06:40:04 CDT