Find the next word using regular expressions in Oracle 10g

From: <admin_at_rbtron.com>
Date: Mon, 9 Feb 2009 08:55:31 -0800 (PST)
Message-ID: <fc2e053d-8915-40f4-ab87-b905bd656a38_at_v42g2000yqj.googlegroups.com>



Hi,

I have the following details in a file:

(ADDRESS =
(CITY_DETAILS = (STREET# = 416)

                      (STREET_NAME =
                      UNITY BLVD.)
                      (CITY = AUSTIN))

(STATE_DETAILS = (STATE_NAME =
TEXAS)(ZIPCODE = 12345)))

I need to pull word after the word STATE_NAME. In this case it is TEXAS. The required word will be enclosed within '=' and ')'. These are multiple line rows.

How to do this using regular expressions in Oracle 10g please ?

Thanx

-GC Received on Mon Feb 09 2009 - 10:55:31 CST

Original text of this message