Oracle ËÄÉáÎåÈ뺯Êý
ceil(number) ´óÓÚ»òµÈÓÚµÄ×îСÕûÊý
floor(number) СÓÚ»òµÈÓÚµÄ×î´óÕûÊý
trunc(number,m) ÔÚÕûÊýnumberµÄmλÖýصôm¼°ÒÔºóµÄλÊý:
Èç:trunc(15.78,1)=15.7
trunc(15.78,-1)=15;
round(number,m) Ó÷¨Í¬trunc,²ÉÓÃËÄÉáÎåÈëµÄ·½Ê½.
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÔÚLinuxÉϰ²×°oracleµÄʱºò²»Ð¡ÐݲװÁËÁ½´Îlistener, ¸ãµÃlistenerµÄ¶Ë¿ÚºÅ±ä³ÉÁË1522¶ø²»ÊÇȱʡµÄ1521, ¿Í»§¶ËÁ¬Á˺þö¼Ã»ÓÐÁ¬½ÓÉÏ£¬×îºó²Å·¢ÏÖÊÇlistenerµÄ¶Ë¿ÚºÅ²»¶Ô¡£Ò»ÏÂÊÇÎҸıälistener¶Ë¿ÚºÅµÄ²½Ö裺
1. Ê×ÏÈÐèҪֹͣlistener, ʹÓÃÃüÁîlsnrctl stop
2. listenerÍ£Ö¹ÒԺ󣬵½ÄãµÄ$ORACLE_HOME/network/adminÏÂÕ ......
ORACLE 10GÔÚLINUXµÄ°²×°:
ÏÈÉÏÀ´Á½ÕÅͼ:
DBAÊÇŬÁ¦µÄ·½Ïò,ORACLE DBA°üÂÞÍòÏó,Á¬LINUX/UNIX¶¼¸ã²»¶¨,»¹ÅªP¸öORACLE°¡.
Á½²¿·Ö:
1.RED HAT ENTERPRISE LINUX 5µÄ°²×°
Äѵã(¶ÔÓÚÏÖÔÚµÄÎÒÀ´Ëµ):1.1YUM±¾µØÔ´µÄÅäÖÃ;ÍøÂçÓÐÏà¹Ø×ÊÁÏ,²»¶à˵ÁË.ÓÉÓÚÊDZ¾»úʹÓÃ,²Î¿¼ÁËFTPÔ´ºó,ÎÒʹÓÃÁËFILEÔ´;
&nb ......
1¡¢×ª»»º¯Êý
Óëdate²Ù×÷¹ØÏµ×î´óµÄ¾ÍÊÇÁ½¸öת»»º¯Êý£ºto_date(),to_char()
to_date() ×÷Óý«×Ö·ûÀàÐͰ´Ò»¶¨¸ñʽת»¯ÎªÈÕÆÚÀàÐÍ£º
¾ßÌåÓ÷¨:to_date(''2004-11-27'',''yyyy-mm-dd''),ǰÕßΪ×Ö·û´®£¬ºóÕßΪת»»ÈÕÆÚ¸ñʽ£¬×¢Ò⣬ǰºóÁ½ÕßÒªÒÔÒ»¶ÔÓ¦¡£
Èç;to_date(''2004-11-27 13:34:43'', ''yyyy ......