Oracle中实现concat_ws

[寻路科技]

oracle有没有可以替代mysql的concat_ws()的函数

[sych888]

SQL> select ename from emp; ENAME ---------- SMITH ALLEN WARD JONES MARTIN BLAKE CLARK SCOTT KING TURNER ADAMS JAMES FORD MILLER 已选择14行。 SQL> select wm_concat(ename) from emp; WM_CONCAT(ENAME) ------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------ SMITH,ALLEN,WARD,JONES,MARTIN,BLAKE,CLARK,SCOTT,KING,TURNER,ADAMS,JAMES,FORD,MILLER

[寻路科技]

替换的是concat_ws函数。例如concat_ws(' ',nt.name,nvl(nt.displayTime,''))这种三参的

[sych888]

引用 2 楼 xiaoyuanzhi123 的回复:

替换的是concat_ws函数。例如concat_ws(' ',nt.name,nvl(nt.displayTime,''))这种三参的

把你想要的结果贴一下

[sych888]

SQL> select ename||','||nvl(job,'') from emp; ENAME||','||NVL(JOB, -------------------- SMITH,CLERK ALLEN,SALESMAN WARD,SALESMAN JONES,MANAGER MARTIN,SALESMAN BLAKE,MANAGER CLARK,MANAGER SCOTT,ANALYST KING,PRESIDENT TURNER,SALESMAN ADAMS,CLERK JAMES,CLERK FORD,ANALYST MILLER,CLERK

[寻路科技]

concat(nt.name,' ')||nvl(nt.displayTime,'')都可以啦