08 2016 档案

Plsql 关于多列合并+判断
摘要：select tpc.cspcode as id , tpc.cspcode||'('||tc.cname||'--'|| DECODE(tsp.cpagedesc,'LENGTH(tsp.cpagedesc)>30','...',tsp.cpagedesc)||')' as text from t 阅读全文
posted @ 2016-08-25 11:38 角儿- 阅读(2047) 评论(0) 推荐(0)