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)
Ïà¹ØÎĵµ£º
NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......
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,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......
˵µ½Èí½âÎö£¨soft prase£©ºÍÓ²½âÎö£¨hard prase£©£¬¾Í²»Äܲ»ËµÒ»ÏÂOracle¶ÔsqlµÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»ÌõsqlÓï¾ä½»¸¶Oracle£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûǰ£¬Oracle¶Ô´Ësql½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
1¡¢Óï·¨¼ì²é£¨syntax check£©
¼ì²é´ËsqlµÄƴдÊÇ·ñÓï·¨¡£
2¡¢ÓïÒå¼ì²é£¨semantic check£©
ÖîÈç¼ì²ésqlÓï¾äÖеķÃÎÊ¶Ô ......