Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ORACLE directory Ŀ¼

Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';
±¾°¸Àý¾ßÌå´´½¨ÈçÏÂ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬¾ßÌåÓï·¨ÈçÏ ......

¹ØÓÚOracle½ø³Ì½á¹¹¼°ºǫ́½ø³Ì¼ò½é


½ø³Ì½á¹¹
½ø³ÌÊDzÙ×÷ϵͳÖеÄÒ»ÖÖ»úÖÆ£¬Ëü¿ÉÖ´ÐÐһϵÁеIJÙ×÷²½¡£ÔÚÓÐЩ²Ù×÷ϵͳÖÐʹÓÃ×÷Òµ(JOB)»òÈÎÎñ(TASK)µÄÊõÓï¡£Ò»¸ö½ø³Ìͨ³£ÓÐËü×Ô¼ºµÄרÓÃ´æ´¢Çø¡£ORACLE½ø³ÌµÄÌåϵ½á¹¹Éè¼ÆÊ¹ÐÔÄÜ×î´ó¡£
ORACLEʵÀýÓÐÁ½ÖÖÀàÐÍ£ºµ¥½ø³ÌʵÀýºÍ¶à½ø³ÌʵÀý¡£
µ¥½ø³ÌORACLE£¨ÓֳƵ¥ÓÃORACLE£©ÊÇÒ»ÖÖÊý¾Ý¿âϵͳ£¬Ò»¸ö½ø³ÌÖ´ÐÐÈ«²¿ORA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ