select (case
when length(t.description)>20 then substr(t.description,0,20)|| '...'
when length(t.description)<20 then t.description
end) a,
TO_CHAR(TRUNC(t.amount,2),'FM999,999,999,999,990.00') b,
(substr(t.number,0,10) || chr(10) || substr(t.number,11,length(t.number))) c
from table t
解释:
1、(case
when length(t.description)>20 then substr(t.description,0,20)|| '...'
when length(t.description)<20 then t.description
end) a,
这段SQL可以限制显示字符个数,超出的以‘...’显示。
2、TO_CHAR(TRUNC(t.amount,2),'FM999,999,999,999,990.00') b
对金额进行格式化
3、(substr(t.number,0,10) || chr(10) || substr(t.number,11,length(t.number))) c
对长一点的编码做换行处理