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

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¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

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

Linuxϰ²×°Oracle 10gÖÐÎÄÂÒÂë

ÔÚCenotOS 5.3ÖÐÎÄ»·¾³Ï°²×°Oracle 10g R2ʱ£¬½øÈëͼÐλ¯½çÃæºó£¬·¢ÏÖÖÐÎÄÂÒÂë¡£
ÔÚÍøÉÏËÑË÷ºó£¬·¢ÏÖÊÇÓÉÓÚLinuxÉÏûÓа²×°Oracle°²×°Ê±Ê¹ÓõÄ×ÖÌå¿âÔì³ÉµÄ¡£
´ÓÒÔÏÂÍøÕ¾ÏÂÔØ×ÖÌå¿â
http://download.csdn.net/source/1073202
È»ºóÔÚLinuxÏÂÖ´ÐÐÒÔÏÂÃüÁ°Ñ×ÖÌå¿â°²×°µ½ÏàӦλÖü´¿É
mkdir -p /usr/share/fonts/zh_CN ......

ORACLE µÈ´ýʼþ ¡¶ÉîÈëdz³öORACLEµÚ°ËÕ¡·

µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ¿µÄµÈ´ýʼþ£¬µ«ÊÇÕâЩµÈ´ýÊ ......

oracle constraints(2)

oracle Ô¼ÊøµÄ״̬
  oracleÔÚ´´½¨Ô¼ÊøºóĬÈÏ״̬ÊÇenabled VALIDATED
SQL> create table T2
2 (
3 VID NUMBER,
4 VNAME VARCHAR2(10) not null,
5 VSEX VARCHAR2(10) not null
6 )
7 /

Table created

SQL> alter table t2 add constraints PK_T primary key (vid); ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ