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

ORACLEÊý¾Ý¿âµÄÊý¾Ýµ¼Èë·½·¨

ÒÔ ÏÂÆßÖÖÊý¾Ýµ¼Èë·½·¨Äĸö×îÊÊÓÃÐèÒªÕë¶Ô¾ßÌåÇé¿ö¾ßÌå·ÖÎö£¬ÎÒÒ²¸½´øÁоÙÁËÓ°Ïìµ¼ÈëËٶȵĸ÷ÖÖÒòËØ¹©Õå×á£ÎªÁ˱Ƚϸ÷ÖÖÊý¾Ýµ¼Èë·½·¨µÄЧ¹û£¬ÎÒ´´½¨ÁËʾÀý±í ºÍÊý¾Ý¼¯£¬²¢Óø÷ÖÖ·½·¨µ¼ÈëʾÀýÊý¾Ý¼¯À´¼ÆËã×ÜÌåµ¼Èëʱ¼äºÍµ¼Èë½ø³ÌÕ¼Óà CPU ʱ¼ä£¬ÕâÀïµÃ³öµÄʱ¼ä½ö¹©²Î¿¼¡£ÐèҪ˵Ã÷µÄÊÇ£¬½¨ÒéÄãʹÓà Oracle 9i ÆóÒµ°æÊý¾Ý¿â£¬µ±È»ÄãÒ²¿ÉÒÔ³¢ÊÔʹÓà Oracle 7.3 ÒÔÉϵıê×¼°æÊý¾Ý¿â¡£±¾ÎÄʹÓõĻúÆ÷ÅäÖÃΪ£ºCPU Intel P4£¬ÄÚ´æ 256M£¬Êý¾Ý¿â Oracle 9i ÆóÒµ°æ¡£
ʾÀý±í½á¹¹ºÍÊý¾Ý¼¯
ΪÁËÑÝʾºÍ±È½Ï¸÷ÖÖÊý¾Ýµ¼Èë·½·¨£¬ÎÒ¼Ù¶¨Êý¾Ýµ¼ÈëÈÎÎñÊǽ«ÍⲿÎļþÊý¾Ýµ¼Èëµ½ Oracle Êý¾Ý¿âµÄCALLS±íÖУ¬ÍⲿÊý¾ÝÎļþ°üº¬Ê®ÍòÌõºô½ÐÖÐÐļǼ£¬½«½ü 6MB µÄÎļþ´óС£¬¾ßÌåµÄÊý¾ÝʾÀýÈçÏÂ:
82302284384,2003-04-18:13:18:58,5001,ͶËß,ÊÖ»úÈý°üάÐÞÖÊÁ¿
82302284385,2003-04-18:13:18:59,3352,×Éѯ,¹©Ë®ÈÈÏߵĺÅÂë
82302284386,2003-04-18:13:19:01,3142,½¨Òé,ÔöÉ蹫½»Ïß·
½ÓÊܵ¼ÈëÊý¾ÝµÄ±íÃûÊÇ CALLS£¬±í½á¹¹ÈçÏ£º
     Name                Null?         Type                 Comment
    ------------     ---------     -------------        -----------------
    CALL_ID          NOT NULL      NUMBER               Primary key
    CALL_DATE        NOT NULL      DATE                 Non-unique index
    EMP_ID           NOT NULL      NUMBER
    CALL_TYPE        NOT NULL      VARCHAR2(12)
 


Ïà¹ØÎĵµ£º

OracleÖÐÓëSQLSERVER ISNULLº¯ÊýÏàͬ×÷Óõĺ¯Êý

NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......

oracle½¨Á¢±í¿Õ¼ä

1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......

OracleµÄÓ²½âÎöºÍÈí½âÎö

˵µ½Èí½âÎö£¨soft prase£©ºÍÓ²½âÎö£¨hard prase£©£¬¾Í²»Äܲ»ËµÒ»ÏÂOracle¶ÔsqlµÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»ÌõsqlÓï¾ä½»¸¶Oracle£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûǰ£¬Oracle¶Ô´Ësql½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
 
1¡¢Óï·¨¼ì²é£¨syntax check£©
¼ì²é´ËsqlµÄƴдÊÇ·ñÓï·¨¡£
2¡¢ÓïÒå¼ì²é£¨semantic check£©
ÖîÈç¼ì²ésqlÓï¾äÖеķÃÎÊ¶Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ