SELECT TKJE FROM CSS_REFUNDS
表 REFUNDS 中TKJE 类型为number(10,2)
要求: 若TKJE 值为NULL 则返回NULL,为0 返回0.
将TKJE转成char类型s
SELECT TO_CHAR(TKJE) FROM CSS_REFUNDS
SELECT TKJE FROM CSS_REFUNDS
表 REFUNDS 中TKJE 类型为number(10,2)
要求: 若TKJE 值为NULL 则返回NULL,为0 返回0.
将TKJE转成char类型s
SELECT TO_CHAR(TKJE) FROM CSS_REFUNDS