Regular Expressions; return a buried match

From: cate <catebekensail_at_yahoo.com>
Date: Wed, 3 Feb 2010 14:43:59 -0800 (PST)
Message-ID: <cf075907-c4ae-41f1-bf7e-ff400f263596_at_b10g2000yqa.googlegroups.com>



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

I want the 5th and 6th digit. Can Oracle do this? Received on Wed Feb 03 2010 - 16:43:59 CST

Original text of this message