Re: An Oracle 10g Question

On Jan 25, 9:46 pm, csn <csn..._at_gmail.com> wrote:
> select
>     regexp_instr('"null","null","null","GMO, DXDT, SDS, QID,
> MZZ","90", "3 ASC"',
>     '"[[:alnum:]]+, .*"',1) pos from dual;
>
> This one looks for
>
> "XXXXXXX,_......."
>
> which is exactly your description, and returns a non-zero code of 22
> which is the starting position in the string.
>
> Note: _ means space.

Last question: Your example seems to work. Now, I'm trying to understand it in english:

There is the string: '"null","null","null","GMO, DXDT, SDS, QID, MZZ","90", "3 ASC"',
And you are looking for one or more alphanumeric characters....

And then I get lost with the .*"',1)

Thanks!! Received on Sat Jan 26 2008 - 15:50:31 CST