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