Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

½ñÌì×°ORACLE µÄµãµãµÎµÎ£¡

ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄ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 ......

½« Google Maps Óë Oracle Êý¾Ý¿â»ì´î

×÷ÕߣºChris Schalk

ÇáËɹ¹½¨Ò»¸ö»ì´îÓ¦ÓóÌÐò£¬ÒÔʹÓà Oracle XML DB ½« Oracle Êý¾ÝÓë Google Maps API ¼¯³É¡£
2007 Äê 8 Ô·¢²¼
ÕýÈçÄúÖªµÀµÄÄÇÑù£¬Ðí¶àÄêÒÔǰ£¬Oracle ¾ÍÄܹ»´ÓÊý¾Ý¿â¼´Ê±Éú³É XML¡£³ýÁË´Ó Oracle Êý¾Ý¿âÉú³É XML£¬»¹¿ÉÒÔʹÓöàÖÖÓïÑÔ£¨Èç Java Servlets ºÍ JDBC£©½«Éú³ÉµÄÊý¾Ý XML ·¢²¼µ½ Web¡£ ......

OracleÎﻯÊÓͼ

OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓÐºÜ¶à·½ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......

³¹µ×Ð¶ÔØORACLE(WINXP)

ÓÃoracleµÄÐ¶ÔØ³ÌÐò²¢²»ÄÜÍêÈ«Ð¶ÔØ¸É¾»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêÈ«Ð¶ÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ  
     Í£Ö¹ËùÓÐOracle·þÎñ¡£  
2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle  -  OraHome81£­£¾Oracle   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ