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

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â

    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒÔÁ¬½ÓºÍ¹ÜÀíºÜ¶àµÄÊý¾Ý¿â·þÎñÆ÷¡£
    ºÍ for MySQL °æ±¾²»Í¬µÄÊÇ£¬Oracle ¹ÜÀíÓÐËüµÄÌØÊâÐÔ¡£Oracle ±ØÐëͨ¹ýËüµÄ OCI ´úÀíº¯Êý¿âÓëÊý¾Ý¿â½øÐÐÁ¬½Ó£¬Navicat µ±È»Ò²ÈƲ»¹ýÕâÒ»µã£¬ËùÒÔ±ØÐëÊ×ÏȽøÐÐ Oracle µÄ oci ÉèÖá£ÅäÖõķ½·¨ÊÇ£¬ÔËÐÐ Navicat µÄ²Ëµ¥“¹¤¾ß/Ñ¡Ï¬ÅäÖÓÆäËü”·ÖÀàÏ嵀 OCI ²ÎÊý£¬°Ñ OCIÀà¿â£¨¶ÔÓ¦oci.dll£©ÎļþµÄ·¾¶ÊäÈ룬°´“È·¶¨”±£´æ¡£
    µ«½ö½öÕâÑù×ö»¹²»¹»£¬ÒòΪÕâÒ»Çж¼ÒÀÀµÓÚÄǸö Oracle µÄ“¼´Ê±¿Í»§¶Ë”Èí¼þ°ü£¬ËùÒÔÐèÒªÏÈÏÂÔØÄǸö InstantClient Èí¼þ°ü£¬ÉÏÃæËµµÄ oci.dll Îļþ¾ÍÔÚÕâ¸ö°üÖС£ÏÂÔØ¸ÃÈí¼þ°üºó½âѹµ½Ò»¸öÎļþ¼Ð£¬»¹ÐèÒª×öµÄÊÇ£¬Ìí¼Ó»·¾³±äÁ¿ TNS_ADMIN ÈÃËüµÄÖµµÈÓÚÕâ¸öÎļþ¼ÐµÄ·¾¶£¬ÔÙÔÚϵͳ±äÁ¿ path ǰ¼ÓÉÏÕâ¸öÎļþ¼ÐµÄ·¾¶¡£ÐÞ¸ÄÕâЩÅäÖòÎÊýºó£¬¿ÉÒÔ²»ÓÃÆô¶¯ Windows ϵͳ¡£
    ÔÙ¾ÍÊÇÐÞ¸Ä×¢²á±í·¾¶ HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Ï嵀 NLS_LANG ¼üÖµ£¬Õâ¸ö¼üÖµÏÖÔÚÊÇ NA£¬Òò´Ë將 NLS_LANG µÄÖµ¸ÄΪ SIMPLIFIED CHINESE_CHINA.ZHS16GBK£¬ºÍ Oracle Êý¾Ý¿â·þÎñÆ÷ÉϵÄÒ»Ö¡£»¹¼ûÓÐÈ˸ɴà°ÑÕâ¸ö NLS_LANG ¼üɾ³ý»ò¸ÄÃû£¬±¾È˲âÊÔÒ²ÊÇ¿ÉÒԵ쬵«²»ÖªµÀ»á²»»á´øÀ´±ðµÄÎÊÌâ¡£
    ÒÔÉÏËù˵µÄ Oracle InstantClient ÅäÖ÷½·¨£¬±¾È˵ÄÎÄÕ¡¶Windows 2003 Ï PHP5.2.5 + Apache2.2.8 + Oracle10g/11g µÄÅäÖá·£¨http://blog.why100000.com/?p=581£©ÀïÓиüÏêϸµÄ˵Ã÷£¬ÕâÀïÔÙÖØ¸´Ò»Ï¡£
    OCI ÅäÖúú󣬾ͿÉÒÔÅäÖà Navicat µÄÁ¬½ÓÁË¡£Á¬½ÓÀàÐÍÓÐ Basic ºÍ TNS Á½ÖÖ£¬µ«±¾ÈËÎÞ·¨Åäͨ Basic ÀàÐÍ£¬¾ÍÅäÖà TNS Á¬½Ó£¬ÕâÐèÒªÔÚ¼´Ê±¿Í»§¶ËÎļþ¼ÐÏ·ÅÒ»¸öÃû×ÖΪ tnsnames.ora µÄÅäÖýâÎöÎļþ£¬ÎļþµÄ¸ñʽÈçÏ£º
    # TNSNAMES.ORA Network Configuration File: ……
    ORCL10 =
      (DESCRIPTION =
      &nbs


Ïà¹ØÎĵµ£º

oracle dblink µÄÓ¦ÓÃ


1¡¢ÓÃdblinkÁ´½Óoracle
£¨1£©ÓëÆ½Ì¨Î޹صÄд·¨£º
create public database
link cdt connect to apps
identified by apps using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.205.100)(PORT = 1541))
)
(CONNECT_DATA =
(SERVICE_NAME = CDT)
)
)'
£¨2£©¿ÉÒÔ½«µ¥ÒýºÅÄÚµÄÄÚÈÝ ......

Oracle Shrink Table


´Ó10g¿ªÊ¼£¬oracle¿ªÊ¼ÌṩShrinkµÄÃüÁ¼ÙÈçÎÒÃǵıí¿Õ¼äÖÐÖ§³Ö×Ô¶¯¶Î¿Õ¼ä¹ÜÀí (ASSM),¾Í¿ÉÒÔʹÓÃÕâ¸öÌØÐÔËõС¶Î£¬¼´½µµÍHWM¡£ÕâÀïÐèҪǿµ÷Ò»µã£¬10gµÄÕâ¸öÐÂÌØÐÔ£¬½ö¶ÔASSM±í¿Õ¼äÓÐЧ£¬·ñÔò»á±¨ ORA-10635: Invalid segment or tablespace type¡£ 
Èç¹û¾­³£ÔÚ±íÉÏÖ´ÐÐDML²Ù× ......

oracle ±Ê¼Ç VI Ö®Óαê (CURSOR)

 Óαê(CURSOR),ºÜÖØÒª
Óαê:ÓÃÓÚ´¦Àí¶àÐмǼµÄÊÂÎñ
ÓαêÊÇÒ»¸öÖ¸ÏòÉÏÏÂÎĵľä±ú(handle)»òÖ¸Õë,¼òµ¥Ëµ£¬Óαê¾ÍÊÇÒ»¸öÖ¸Õë
1 ´¦ÀíÏÔʽÓαê
  ÏÔʽÓα괦ÀíÐè 4¸ö PL/SQL ²½Öè,ÏÔʾÓαêÖ÷ÒªÓÃÓÚ´¦Àí²éѯÓï¾ä
  (1) ¶¨ÒåÓαê
  ¸ñʽ:  CURSOR cursor_name [(partment[,parameter]...)] IS s ......

OracleÖеÄNullÖµ½âÎö

         ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......

Oracle ±íÁ¬½Ó·½Ê½·ÖÎö

Ò» ÒýÑÔ
Êý¾Ý²Ö¿â¼¼ÊõÊÇĿǰÒÑÖªµÄ±È½Ï³ÉÊìºÍ±»¹ã·º²ÉÓõĽâ¾ö·½°¸£¬ÓÃÓÚÕûºÍµçÐÅÔËÓªÆóÒµÄÚ²¿ËùÓзÖÉ¢µÄԭʼҵÎñÊý¾Ý£¬²¢Í¨¹ý±ã½ÝÓÐЧµÄÊý¾Ý·ÃÎÊÊֶΣ¬¿ÉÒÔÖ§³ÖÆóÒµÄÚ²¿²»Í¬²¿ÃÅ£¬²»Í¬ÐèÇ󣬲»Í¬²ã´ÎµÄÓû§ËæÊ±»ñµÃ×Ô¼ºËùÐèµÄÐÅÏ¢¡£Êý¾Ý²Ö¿âϵͳÐèÒªÄܹ»¼°Ê±µØ×·×ٺͷÖÎö´óÁ¿µÄÀúÊ·Êý¾Ý£¬²¢Äܹ»¼°Ê±×ö³ö·ÖÎöºÍÔ¤²â£¬Òò´ËÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ