17,377
社区成员
发帖
与我相关
我的任务
分享
select rtrim(to_char(5,'fm0.99'),'.') from dual;
select rtrim(to_char(.5,'fm0.99'),'.') from dual;
select rtrim(to_char(.05,'fm0.99'),'.') from dual;
select rtrim(to_char(5,'fm0.99'),'.') from dual;
select rtrim(to_char(.5,'fm0.99'),'.') from dual;
select rtrim(to_char(.05,'fm0.99'),'.') from dual;
SELECT TO_CHAR('01110' + 1) FROM dual;
SELECT TO_CHAR(-10000,'L99G999D99MI') "Amount"
FROM DUAL;
SELECT TO_CHAR(-10000,'L99G999D99MI',
'NLS_NUMERIC_CHARACTERS = '',.''
NLS_CURRENCY = ''AusDollars'' ') "Amount"
FROM DUAL;
select to_number(to_char(50000 / 10000,'000.00000')) from dual