Oracle ¿Í»§¶Ë C# Á¬½Ó
Ò»¸öÈí¼þ£¬°²×°ÁËoracle¿Í»§¶Ë£¬ÅäÖÃÐÅÏ¢ÈçÏÂ
service identification
servce name: MYSYS
sid »ÒÉ«
connection type: database default
use oracle8i ... ûÓÐÑ¡ÖÐ
address configureation
address1
protocol: tcp/ip
hostname 10.3.1.1
port: 1425
ÁíÍâ²Î¼ûÎÒÕâ¸öÌû×Ó£¬Ñ°ÕÒÁ¬½ÓÊý¾ÝµÄÓû§ÃûºÍÃÜÂ벿·Ö
http://topic.csdn.net/u/20100112/10/98222f13-6906-4282-97e4-5e87333d1160.html
ÎÒÔÚ°²×°Ä¿Â¼ÏÂÕÒµ½Ò»¸öxmlÎļþÓÐÈçϵIJ¿·ÖÃèÊöÊý¾ÝÁ¬½ÓµÄ
<configuration>
<appSettings>
<add key ="OracleConnectionString" value="Password=Xmy10%cam;User ID=mytest;Data Source=MYTEST"> </add>
.... </appSettings>
</configuration>
²»ÖªµÀÊDz»ÊÇ£¬ÓÐÈçÉÏÐÅÏ¢£¬ÎÒÒªÈçºÎ²ÅÄÜÁ¬½ÓÊý¾Ý¿â£¬²éѯÊý¾ÝÄØ£¬Ð»Ð»¡£
Ôõô´ò¿ªÁ¬½ÓÄØ£¿ÎÒ¶Ôoracle²»¶®£¬µ«ÎÒ¶®µãsql
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......