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

ORACLE¶à±í²éѯÓÅ»¯

 ×ª×ÔijµØ,¶Ô×÷ÕߺÜÀ¢¾Î- -!²»ÏþµÃµØÖ·ÁË..
ORACLE¶à±í²éѯÓÅ»¯
ÕâÀïÌṩµÄÊÇÖ´ÐÐÐÔÄܵÄÓÅ»¯,¶ø²»ÊǺǫ́Êý¾Ý¿âÓÅ»¯Æ÷×ÊÁÏ:
²Î¿¼Êý¾Ý¿â¿ª·¢ÐÔÄÜ·½ÃæµÄ¸÷ÖÖÎÊÌâ,ÊÕ¼¯ÁËһЩÓÅ»¯·½°¸Í³¼ÆÈçÏÂ(µ±È»,ÏóË÷ÒýµÈÓÅ»¯·½°¸Ì«¹ý¼òµ¥¾Í²»ÁÐÈëÁË,ºÙºÙ):
Ö´Ðз¾¶:ORACLEµÄÕâ¸ö¹¦ÄÜ´ó´óµØÌá¸ßÁËSQLµÄÖ´ÐÐÐÔÄܲ¢½ÚÊ¡ÁËÄÚ´æµÄʹÓÃ:ÎÒÃÇ·¢ÏÖ,µ¥±íÊý¾ÝµÄͳ¼Æ±È¶à±íͳ¼ÆµÄËÙ¶ÈÍêÈ«ÊÇÁ½¸ö¸ÅÄî.µ¥±íͳ¼Æ¿ÉÄÜÖ»Òª0.02Ãë,µ«ÊÇ2ÕűíÁªºÏͳ¼Æ¾Í¿ÉÄÜÒª¼¸Ê®±íÁË.ÕâÊÇÒòΪORACLEÖ»¶Ô¼òµ¥µÄ±íÌṩ¸ßËÙ»º³å(cache buffering) ,Õâ¸ö¹¦Äܲ¢²»ÊÊÓÃÓÚ¶à±íÁ¬½Ó²éѯ..Êý¾Ý¿â¹ÜÀíÔ±±ØÐëÔÚinit.oraÖÐΪÕâ¸öÇøÓòÉèÖúÏÊʵIJÎÊý,µ±Õâ¸öÄÚ´æÇøÓòÔ½´ó,¾Í¿ÉÒÔ±£Áô¸ü¶àµÄÓï¾ä,µ±È»±»¹²ÏíµÄ¿ÉÄÜÐÔÒ²¾ÍÔ½´óÁË.
µ±ÄãÏòORACLEÌá½»Ò»¸öSQLÓï¾ä,ORACLE»áÊ×ÏÈÔÚÕâ¿éÄÚ´æÖвéÕÒÏàͬµÄÓï¾ä.
ÕâÀïÐèҪעÃ÷µÄÊÇ,ORACLE¶ÔÁ½Õß²ÉÈ¡µÄÊÇÒ»ÖÖÑϸñÆ¥Åä,Òª´ï³É¹²Ïí,SQLÓï¾ä±ØÐë
ÍêÈ«Ïàͬ(°üÀ¨¿Õ¸ñ,»»ÐеÈ).
      ¹²ÏíµÄÓï¾ä±ØÐëÂú×ãÈý¸öÌõ¼þ:
A.       ×Ö·û¼¶µÄ±È½Ï:
µ±Ç°±»Ö´ÐеÄÓï¾äºÍ¹²Ïí³ØÖеÄÓï¾ä±ØÐëÍêÈ«Ïàͬ.
       ÀýÈç:
           SELECT * from EMP;
       ºÍÏÂÁÐÿһ¸ö¶¼²»Í¬
           SELECT * from EMP;
           Select * from Emp;
           SELECT       *      from EMP;
B.       Á½¸öÓï¾äËùÖ¸µÄ¶ÔÏó±ØÐëÍêÈ«Ïàͬ:
   Óû§¶ÔÏóÃû                       ÈçºÎ·ÃÎÊ
Jack   sal_limit                      private synonym
Work_city                    &nbs


Ïà¹ØÎĵµ£º

oracle´æ´¢¹ý³ÌÓ÷¨

  ´æ´¢¹ý³ÌÔÚ·þÎñÆ÷¶ËÔçÒѱ༭ִÐйýµÄ´úÂë¡£Óû§Òª×öµÄÖ»Êǵ÷ÓúͽÓÊÕ´æ´¢¹ý·µ»ØµÄ½á¹û¡£ËùÒÔµ÷Óô洢¹ý³Ì±ÈÆÕͨµÄÓòéѯÓï¾ä·µ»ØÖµÒª¿ìµÃ¶à,´æ´¢¹ý³ÌµÄÖ´ÐÐËٶȸü¿ì,´æ ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý ......

oracle 10g°²×°ÖгöÏÖÎÊÌâ½â¾ö¹ý³Ì

      ÔÚ°²×°oracleµÄDBCA¹ý³ÌÖУ¬ÔÚ´´½¨²¢Æô¶¯oracleʵÀý£¨´´½¨¿Ë¡Êý¾Ý¿â£¬½ø¶ÈÌõÔÚ45%£©¾Í½øÐв»ÏÂÈ¥ÁË£¬ÖØ×°Á˼¸´ÎÖÕÓÚÕÒµ½ÎÊÌâµÄÖ¢½áÁË£¬½â¾ö¹ý³ÌÈçÏ£º
      1¡¢×°Á˼¸±é¾ÍÊÇÄǸöÎÊÌ⣬ÎÒͻȻÏëµ½Òª¿´¿´°²×°ÈÕÖ¾¡£
      2¡¢ÊÇÔÚ´´½ ......

Oracle ¼¸¸ö·þÎñ¸÷´ú±íʲô×÷ÓÃ?

×ªÔØ×Ô http://hi.baidu.com/libinichen/blog/item/9e13ac31175877a95edf0e0b.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ÌΪORACLE.EXE£¬²ÎÊýÎļþ ......

oracleʵ¼ù

1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆÌ¨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ