例子1:
运行结果:
docs
------------
xxx
xxx
xxx
例子2:
运行结果:
docs
------------
xxx,xxx,xxx
select nDocId as docs from wf_doc_gw
where nProcId = 64 and nProcStatus=1 and nState=0
and cProcUserList is null
order by nDocId;
运行结果:
docs
------------
xxx
xxx
xxx
例子2:
select wmsys.wm_concat(ndocId) as docs from wf_doc_gw
where nProcId = 64 and nProcStatus=1 and nState=0
and cProcUserList is null
order by nDocId;
运行结果:
docs
------------
xxx,xxx,xxx