REGEXP_SUBSTR() is always NULL

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Thu, 25 Jun 2009 13:29:22 +0200
Message-ID: <h1vn6j$dul$1_at_news.eternal-september.org>

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

Received on Thu Jun 25 2009 - 06:29:22 CDT