– 多个字段拼接(多行也可以拼接)
select c.flowinstid,
WM_CONCAT(’{’ || c.creator || ‘};’ || c.content || ‘;’ ||
to_char(c.createdate, ‘yyyy-mm-dd hh24:mi:ss’)) defectComment
from DEFECT_PM_DEFECT_COMMENT c
group by c.flowinstid;
– 结果示例
flowinstid defectComment
10688667 {wangmeng7};aaaaaaaaaaaaaaaabbbbbbbbb;2018-06-13 10:02:56,{zhaochunbo};asdfasfasfasgasgasgas;2018-06-13 10:03:05
–待定
select defect_id, title,defectdescription
from DEFECT_PM_DEFECT_LIST
where instr(defect_id || UPPER(title), UPPER(‘test’)) + instr(UPPER(defectdescription), UPPER(‘Test’)) > 0;
–sql 中运用if条件取值
select decode(a.testescape,‘yes’,a.escapereason,‘no’,‘否’,null) from DEFECT_PM_DEFECT_LIST a where a.FLOWINSTID=‘11498533’;–yes
–yes --个梵蒂冈地方
–值:个梵蒂冈地方
select decode(a.testescape,‘yes’,a.escapereason,‘no’,‘否’,null) from DEFECT_PM_DEFECT_LIST a where a.FLOWINSTID=‘12418505’;–no
–no --