oracle字符的sc,Oracle 分割字符查询

Oracle 分割字符查询

select *

from view_psbaseinfo

where DECODE('410782001125,411100000043',

'',

NULL,

'410782001125,411100000043') IS NULL

or PSCODE in

(SELECT REGEXP_SUBSTR('410782001125,411100000043', '[^,]+', 1, LEVEL) AS PSCODE

FROM DUAL

CONNECT BY LEVEL <=

LENGTH('410782001125,411100000043') + 1 -

LENGTH(REPLACE('410782001125,411100000043', ',', '')));

原文：http://blog.csdn.net/mh942408056/article/details/36672553