Plsql 关于多列合并+判断

select tpc.cspcode as id , tpc.cspcode||'('||tc.cname||'--'|| DECODE(tsp.cpagedesc,'LENGTH(tsp.cpagedesc)>30','...',tsp.cpagedesc)||')' as text from t_page_channels tpc inner join t_channels tc on tpc.ccode = tc.ccode inner join t_spead_page tsp on tpc.cpagecode = tsp.cpagecode where 1 = 1

转载于:https://www.cnblogs.com/Syh0371/p/5806142.html

相关资源：数据结构—成绩单生成器