如图,我想把jsxm这个字段,带'/'号的记录拆分成多条记录。一个姓名对应一条数据,sql语句应该怎么写?我是ORACLE10G的数据库select '(2017-2018-1)-03203058-018015-1' xkkh,'03203058' kcdm,'0102001' jszgh,'文三/刘三群/沈三平' jsxm from dual
union
select '(2017-2018-1)-03203058-018015-2' xkkh,'03203058' kcdm,'0102001' jszgh,'文三/沈三平' jsxm from dual
union
select '(2017-2018-1)-5105002Y-018015-1' xkkh,'5105002Y' kcdm,'0102001' jszgh,'文三' jsxm from dual