Re: An Oracle 10g Question

From: csn <>
Date: Fri, 25 Jan 2008 19:46:09 -0800 (PST)
Message-ID: <>


    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. Received on Fri Jan 25 2008 - 21:46:09 CST

Original text of this message