An Oracle 10g Question

From: <amerar_at_iwc.net>
Date: Fri, 25 Jan 2008 13:00:17 -0800 (PST)
Message-ID: <3e1bd496-c0a3-4623-aecd-666ea72b10de@q77g2000hsh.googlegroups.com>

Hi All,

First, thanks to those who helped me eariler in the week with that complex regular expression. I have another one.

Here is my string: "null","null","null","GMO, DXD, SDS, QID, MZZ","90", "3 ASC" It can obviously vary, but what I am looking for is the occurrence of this part: "GMO, DXDT, SDS, QID, MZZ"

Basically I need to know if a string like that exists within the entire string. Notice that there are multiple values within the double quotes.

The problem is that the last parameter is the same, but I do not want to process that parameter.....it's hard to tell the difference, which is what makes this a nutty thing.....

I'm hoping to use some type of 10g regular expression within my PLSQL to find it, and then to process it one way or the other if it exists of not......

Thanks All!!! Received on Fri Jan 25 2008 - 15:00:17 CST

Original text of this message