Re: An Oracle 10g Question
From: csn <csn233_at_gmail.com>
Date: Fri, 25 Jan 2008 19:46:09 -0800 (PST)
Message-ID: <96e73ae9-d797-4256-b941-40ccd324eec5@d4g2000prg.googlegroups.com>
Date: Fri, 25 Jan 2008 19:46:09 -0800 (PST)
Message-ID: <96e73ae9-d797-4256-b941-40ccd324eec5@d4g2000prg.googlegroups.com>
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. Received on Fri Jan 25 2008 - 21:46:09 CST