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.

I'm going to give this a try. But one quick thing: What is [[:alnum:]] mean??? All numbers??? Received on Sat Jan 26 2008 - 15:34:45 CST