oracle sql使用总结

1.按照in的顺序查询出结果排序
select xh,xm from XJGL_ZXSJBXX where xh in (

'2120196132',

'2120196133'

) ORDER BY INSTR('

2120196132,

2120196133

', xh)

2.sql更新 如果为空按照第二个更新，如果不为空按照第一个更新

update PY_HISTORY_CJ_FORMAL set xm = nvl('','曹雅娴') where id = 'BCDA16ED36554E17E0530100007FDCEB';

3.多行拼接函数
用于查询结果多行拼接。
SELECT
LISTAGG(GOODSNAME,';') WITHIN GROUP (ORDER BY GOODSNAME) AS sd
FROM DIM_ERP_PUB_GOODS WHERE ROWNUM<4

 WM_CONCAT()  方法被替代成：LISTAGG(GOODSNAME,';') WITHIN GROUP (ORDER BY GOODSNAME) AS sd

oracle sql使用总结

推荐阅读