oracleÖеÄto_char()
½éÉÜto_char(Êý×Ö, ‘¸ñʽ’)£¬±È½Ï³£Óõĸñʽ
9 ±íʾÓÐЧλÊý
0 ÓÃ0²¹×ãλÊý
B Óÿոñ²¹×ãλÊý
ÔÊýµÄλÖÃÓÐʵ¼ÊÊý×ÖռλµÄʱºò£¬0ºÍ9µÄЧ¹ûÊÇÒ»ÑùµÄ¡£
0ºÍ9µÄÇø±ðÔÚÓÚ¸ñʽÖеÄÄÇһλÖÃʵ¼ÊÊý×ÖûÓÐվλµÄÇé¿öÏ¡£
select to_char(0.45,'0.99'); ½á¹ûÊÇ0.45
select to_char(0.45,'9.99'); ½á¹ûÊÇ.45
select to_char(2.45,'0.99'); ½á¹ûÊÇ2.45
select to_char(2.45,'9.99'); ½á¹ûÊÇ2.45
ÒòΪ0.45µÄÓÐЧÊý×ÖÊÇСÊýµãºóµÚһλ£¬Ð¡ÊýµãǰûÓÐÓÐЧÊý×Ö£¬¸ÄΪÈç¹ûÏëÒªÏÔʾµÄ»°£¬¾ÍÒªÓÃ0À´²¹³äλÊý¡£
Àý×Ó£º
SELECT
to_char(123.45, '0009.9'),
to_char(123.45, '9999.9'),
to_char(123.45, 'B999.9')
from dual;
½á¹ûΪ
TO_CHAR(123.45,'0009.9') TO_CHAR(123.45,'9999.9') TO_CHAR(123.45,'B999.9')
------------------------ ------------------------ ------------------------
0123.5 123.5 123.5
Ïà¹ØÎĵµ£º
ËäÈ»ÒÔÇ°ÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
1. Oracle 10g windows ƽ̨Ï°²×°
¡¡¡¡ÏÂÔصØÖ·£º http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......
## Oracle Êý¾Ýµ¼Èëµ½ Mysql ##
__________________________________________ ......
ʹÓÃultraedit32´ò¿ªµ¼³öµÄdmpÎļþ£¬ÎļþÄÚÈÝÒÔÊ®Áù½øÖÆÏÔʾÊý¾Ý£¬ÆäÖеڶþ¡¢Èý×Ö½ÚµÄÊý¾Ý¼Ç¼µÄÊÇ´ËÎļþµÄ×Ö·û¼¯¡£
ÀýÈ磺
03 54
½«Æäת»»Îª10½øÖÆ£¬ÖµÎª852£¬Ê¹ÓÃÃüÁî
select nls_charset_name(852) from dual
µÃµ½½á¹û
ZHS16GBK
µ±Ç°Ê¹ÓÃwinXP¼òÌåÖÐÎIJÙ×÷ϵͳ£¬Oracle¿Í»§¶ËĬÈÏ×Ö·û¼¯ÎªGBK¡£
´´½¨Êý¾Ý¿â£¬É趨 ......