Re: Regular Expressions; return a buried match

From: Malcolm Dew-Jones <>
Date: 3 Feb 2010 16:14:08 -0700
Message-ID: <4b6a1150$>

cate ( wrote:
: select REGEXP_SUBSTR(encodedField, '^\d{4}(\d\d)') from table;

: I want the 5th and 6th digit. Can Oracle do this?

In 10GR1 not directly in one regexp. In this case substr(result,5,2) would help. In other versions with regexp's I assume the same, but you could always check yourself

        google: REGEXP_SUBSTR 10GR2 download Received on Wed Feb 03 2010 - 17:14:08 CST

Original text of this message