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

Oracle Êý¾Ý¿âµÄ°²×°

 
   ×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ÓµÄ×¢Òâ¿©¡£
      ÏÖÔÚÖÕÓڴ󹦸æ³É£¬ºÃÏë¿Þ£¡ ÕâÊÇÎÒµÚÒ»´ÎÕâÑùÏàÐÅ×Ô¼º£¬Ð»Ð»ÍøÓѵÄһЩ°ï£¬http://blog.csdn.net/xiaoyao6650/archive/2009/03/15/3989484.aspx£¬½ñÌìÓÖ×°ÁËVS2008£¬ÀÏÊÇÌø³öWEB×é¼þ°²×°Ê§°Ü£¬ÆøËÀÁË£¬
ÏÖÔÚÖÕÓÚ¸ãºÃÁË£¬Ô­À´ÊÇoffice_zh-cnµÄÎÊÌ⣬ÖÕÓڵõ½Á˽â¾ö¡£
       ÖÐÎç·¸Á˸ö´íÎó£¬ÌýÐÅÍøÓѵķ½·¨£¬ÐÞ¸ÄÁËÓû§µÄÕË»§£¬×îºó½øÈëF8²ÅµÃ½â¾ö£¬¿´À´µÃ×Ô¼º¶à¶¯¶¯ÄÔ×Óȥ˼¿¼°¡£¡
        ¾­ÀúÁËÕâЩÊÂÇ飬¸ü¼Ó¼á¶¨ÁË×Ô¼ºÒª×ߵķ£¬Chang,ÎÒÃÇÒ»ÆðŬÁ¦°É£¡ÏàÐÅ£¬ÎÒÏàÐÅÎÒÐеģ¬ÄãÒ²Ò»¶¨»áµÄ£¬²»ÊǵÄô£¬MyLove !


Ïà¹ØÎĵµ£º

´´½¨oracle dblink

create database link user_auth
¡¡¡¡ connect to user_auth identified by user_auth
¡¡¡¡ using  '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.236)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=develop1)))'; ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵Ľâ¾ö·½·¨£¨»ã×Ü£©

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵Ľâ¾ö·½·¨£¨»ã×Ü£©
oracle 10g em¡¢isqlplusµÄ¹ÜÀí
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§               ......

Oracle Group By Ó÷¨Ö® —— Having

¿Í»§ÐèÇó·ÖÎö£º
¡¡¡¡±ÊÕß×î½ü½Óµ½Ò»¼Ò¿Í»§µÄÒ»¸öÐèÇó¡£ËûÃDz¿ÊðÁËÒ»¸öERPϵͳ£¬ÏÖÔÚ²ÉÓõľÍÊÇOracleÊý¾Ý¿â¡£ÏÖÔÚÓÉÓÚÆóҵͳ¼Æ·ÖÎöµÄÐèÒª£¬ÒªÊµÏÖÈçϵÄÐèÇó¡£
¡¡¡¡1¡¢°´Ô·ÝÀ´Í³¼Æ2009ÄêµÚÒ»¼¾¶Èÿ¸ö¹©Ó¦É̵IJɹº½ð¶î¡£Ò²¾ÍÊÇ˵£¬ÔÚ±¨±íÖÐÒªÄܹ»ÏÔʾ³ö2009Äê1Ô·ݡ¢2Ô·ݡ¢3Ô·ݹ©Ó¦É̵IJɹº½ð¶îºÏ¼Æ£¬²»ÐèÒªÃ÷ϸ¡£
¡¡¡ ......

ORACLEµÄÈý¸öÅäÖÃÎļþ½éÉÜ


ÔÚoracle°²×°Ä¿Â¼$HOME/network/adminÏ£¬¾­³£¿´µ½sqlnet.ora tnsnames.ora
listener.oraÕâÈý¸öÎļþ£¬³ýÁËtnsnames.ora£¬ÆäËûÁ½¸öÎļþÏêϸµÄÓÃ;ºÜ¶àÈ˶¼²»Ì«Á˽⡣
sqlnet.ora ÓÃÔÚoracle client¶Ë£¬ÓÃÓÚÅäÖÃÁ¬½Ó·þÎñ¶ËoracleµÄÏà¹Ø²ÎÊý.
tnsnames.ora ÓÃÔÚoracle
client¶Ë£¬Óû§ÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ±ðÃû²ÎÊý,¾ÍÏñÏµÍ³Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ