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

Oracleº¯Êý

CLOB:ÓÃÀ´´æ´¢µ¥×Ö½ÚµÄ×Ö·ûÊý¾Ý
NCLOB:ÓÃÀ´´æ´¢¶à×Ö½ÚµÄ×Ö·ûÊý¾Ý
BLOB£ºÓÃÓÚ´æ´¢¶þ½øÖÆÊý¾Ý
BFILE:´æ´¢ÔÚÎļþÖеĶþ½øÖÆÊý¾Ý£¬Õâ¸öÎļþÖеÄÊý¾ÝÖ»Äܱ»Ö»¶Á·Ã¡£µ«¸ÃÎļþ²»°üº¬ÔÚÊý¾Ý¿âÄÚ¡£
CLOB£¬NCLOB£¬BLOB¶¼ÊÇÄÚ²¿µÄLOBÀàÐÍ£¬×4G£¬Ã»ÓÐLONGÖ»ÄÜÓÐÒ»ÁеÄÏÞÖÆ¡£
select lpad(to_number(nvl(max(classid),to_number(002)*1000)) + 1,length('parentid')+3,'0') from courseclass where parentid = 002
select lpad(to_number(nvl(max(classid),to_number(0)*1000)) + 1,decode(0,0,3,length(0)+3),'0') from courseclass where parentid = 0
1.TRUNC(for dates)
        TRUNCº¯ÊýΪָ¶¨ÔªËضø½ØÈ¥µÄÈÕÆÚÖµ¡£
        Æä¾ßÌåµÄÓï·¨¸ñʽÈçÏ£º
        TRUNC£¨date[,fmt]£©
        ÆäÖУº
        date        Ò»¸öÈÕÆÚÖµ
        fmt                ÈÕÆÚ¸ñʽ£¬¸ÃÈÕÆÚ½«ÓÉÖ¸¶¨µÄÔªËØ¸ñʽËù½ØÈ¥¡£ºöÂÔËüÔòÓÉ×î½üµÄÈÕÆÚ½ØÈ¥
        ÏÂÃæÊǸú¯ÊýµÄʹÓÃÇé¿ö£º
        TRUNC£¨TO_DATE(’24-Nov-1999 08:00 pm’,’dd-mon-yyyy hh:mi am’)£©
                =’24-Nov-1999 12:00:00 am’
        TRUNC£¨TO_DATE(’24-Nov-1999 08:37 pm’,’dd-mon-yyyy hh:mi am’,’hh’)£©        =’24-Nov-1999 08:00:00 am’
2.TRUNC(for number)
        TRUNCº¯Êý·µ»Ø´¦ÀíºóµÄÊýÖµ£¬Æä¹¤×÷»úÖÆÓëROUNDº¯Êý¼«ÎªÀàËÆ£¬Ö»ÊǸú¯Êý²»¶ÔÖ¸¶¨Ð¡Êýǰ»òºóµÄ²¿·Ö×öÏàÓ¦ÉáÈëÑ¡Ôñ´¦Àí£¬¶øÍ³Í³½ØÈ¥¡£
        Æä¾ßÌåµÄÓï·¨¸ñʽÈçÏÂ
        TRUNC£¨number[,decimals]£©
        ÆäÖУº
        number        ´ý×ö½ØÈ¡´¦ÀíµÄÊýÖµ
        decimals        Ö¸Ã÷Ðè±£ÁôСÊýµãºóÃæµÄλÊý¡£¿ÉÑ¡ÏºöÂÔËüÔò½ØÈ¥ËùÓеÄСÊý²¿·Ö
        ÏÂÃæÊǸú¯ÊýµÄʹ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleÈÕÆÚº¯Êý²Ù×÷(ÊÕ¼¯ÕûÀí°æ)

¾­³£ÔÚÆ½Ê±µÄ¿ª·¢ÖÐÒªÓõ½oracleµÄÈÕÆÚº¯Êý£¬Ã¿´Î¶¼ÒªÉÏÍøÈ¥²é£¬ÏÖÔÚÓеãʱ¼ä£¬×Ô¼ºÊÕ¼¯ÕûÀíÁËһϡ£ÌùÔÚÕâÀ·½±ã×Ô¼º£¬Ò²·½±ã´ó¼Ò¡£
---------------------------------------------------------------------------------------------------------------------------------- 
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°È ......

´«ÖDz¥¿Í 2010 1 19Ê®°Ë¡¢ORACLE(2)_ µ¥Ðк¯Êý


¶ÔÿһÐÐÊäÈëÖµ½øÐмÆË㣬µÃµ½ÏàÓ¦µÄ¼ÆËã½á¹û£¬·µ»Ø¸øÓû§£¬Ò²¾ÍÊÇ˵£¬Ã¿ÐÐ×÷Ϊһ¸öÊäÈë²ÎÊý£¬¾­¹ýº¯Êý¼ÆËãµÃµ½Ã¿ÐеļÆËã½á¹ûÊǵ¥Ðк¯Êý¡£
Ò»¡¢×Ö·ûº¯Êý
1¡¢×Ö·û´®´óСдת»»
(1)LOWER (strexp)    ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
(2)UPPER (strexp)     ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ× ......

oracleÌØÊ⺯ÊýÓ÷¨

<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·­ÒëÖµ1,Öµ2,·­ÒëÖµ2,...Öµn,·­ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·­ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......

Oracle Spatail ÌØÀí´æ´¢½á¹¹

MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâÐ©×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ­´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ