to_char() oracle 用法

来源:互联网 发布:海湾战争中国知乎 编辑:程序博客网 时间:2024/05/21 20:09

 select tmp.cus_code, cus.cus_name, to_char(tmp.receive,'fm999,999,999,999,990')receive,to_char(tmp.sellout,'fm999,999,999,999,990')sellout,to_char(tmp.marksellout,'fm999,999,999,999,990')marksellout, to_char(tmp.stock,'fm999,999,999,999,990')stock, to_char(tmp.price,'999,999,999,999,999.99')price,cus.rep_sales from

原创粉丝点击