Find the next word using regular expressions in Oracle 10g
Date: Mon, 9 Feb 2009 08:55:31 -0800 (PST)
I have the following details in a file:
(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 ?
-GC Received on Mon Feb 09 2009 - 10:55:31 CST