select XMLAGG(XMLELEMENT(E, pid || ‘,’)).EXTRACT(’//text()’).getclobval() as pids from T05_LOCKS where sid<3000
但 既然这样了,说明需求有问题
select XMLAGG(XMLELEMENT(E, pid || ‘,’)).EXTRACT(’//text()’).getclobval() as pids from T05_LOCKS where sid<3000
但 既然这样了,说明需求有问题