select length(23),length(-23) from dual; LE..."/>
您好,登錄后才能下訂單哦!
1,number----char(to_char)
一個(gè)數(shù)字在轉(zhuǎn)成字符類型,在指定了格式時(shí)正數(shù)會(huì)多一個(gè)字節(jié)用來存儲(chǔ)前面的‘+’
SQL> select length(23),length(-23) from dual;
LENGTH(23) LENGTH(-23)
---------- -----------
2 3
SQL> select length(to_char(23)),length(to_char(-23)) from dual;
LENGTH(TO_CHAR(23)) LENGTH(TO_CHAR(-23))
------------------- --------------------
2 3
SQL> select length(to_char(23,'99')),length(to_char(-23,'99')) from dual;
LENGTH(TO_CHAR(23,'99')) LENGTH(TO_CHAR(-23,'99'))
------------------------ -------------------------
3 3
多出的占位符用空格補(bǔ)充
SQL> select length(to_char(23,'S99')),length(to_char(0,'S99')) from dual;
LENGTH(TO_CHAR(23,'STM9')) LENGTH(TO_CHAR(0,'S99'))
-------------------------- ------------------------
3 3
可以通過使用‘S’來顯示‘+’
SQL> select to_char(23,'S99'),to_char(-23,'S99') from dual;
TO_CHAR(23,'S99') TO_CHAR(-23,'S99')
----------------- ------------------
SQL> select length(to_char(23,'TM9')),length(to_char(-23,'TM9')) from dual;
LENGTH(TO_CHAR(23,'TM9')) LENGTH(TO_CHAR(-23,'TM9'))
------------------------- --------------------------
2 3
TM最小格式輸出,會(huì)去掉空格以及前面的‘+’,同不帶格式參數(shù)一樣
SQL> select length(to_char(23,'TM9')),length(to_char(-23,'TM9')) from dual;
LENGTH(TO_CHAR(23,'TM9')) LENGTH(TO_CHAR(-23,'TM9'))
------------------------- --------------------------
2 3
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。