Select a.*,
regexp_substr(POST_USEE_DEPT, '[^,]+', 1, level) POST_USEE_DEPT_FEN
from SM_POST a
connect by level <= regexp_count(POST_USEE_DEPT, ',') + 1
and SM_POST_ID = prior SM_POST_ID
and prior dbms_random.value is not null;
ORACLE将用逗号隔开的某一条数据,转化为多条
最新推荐文章于 2024-07-09 17:25:15 发布