vs2008Á¬½Óoracleʱ±¨´í
System.Data.OracleClient ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾ ÎÒÔÚÆäËûÏîÄ¿ÖпÉÒÔÕý³£Á¬½ÓµÄ£¬ÍøÉϵķ½·¨¶¼ÊÇ˵ȨÏÞʲôµÄ
²»Çå³þ~ ²»²»ÖªµÀÄãµÄ ´úÂëÊÇÔõôдµÄ Oracle°²×°Îļþ¼Ð,¿ªÆôIUser_*Óû§ËùÓÐȨÏÞ ²Î¿¼FortuneBase ²Î¿¼µØÖ·www.cnblogs.com/mail-ricklee ÕâÊÇÎÒÔÚ·þÎñ³ÌÐòÀïµÄ¼ÆÊ±Æ÷ÀïдµÄÒ»¸öÁ¬½Ó£¬È»ºó¾Í±¨Á¬½Ó±»¹Ø±Õ£¬Á¬µ½µÄÊÇÒ»¸öÔ¶³ÌÊý¾Ý¿â C# code: string constring = "User ID=mydatabase;password=123;Data Source=orcl";//¶¨ÒåÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´® OracleConnection conn = new OracleConnection(constring);//½øÐÐÁ¬½Ó,ÔÚÕâÀï¾ÍÓÐÒì³£³öÏÖÁË ÎÒ¿ªÌûдµÄʱºò£¬µ÷ÓõÄÊÇÔÏÈÓõÄÊý¾Ý¿âÁ¬½ÓµÄÀà¿â£¬¾Í³öÏÖ¸ü¸ß°æ±¾£»ºóÀ´ÎÒ×Ô¼ºÐ´£¬¾Í·¢ÏÖÔÚ·þÎñ³ÌÐòÀïÁ¬½ÓÊý¾Ý¿â¾Í²»ÐÐÒýÓà ÎÒ¿ªÌûдµÄʱºò£¬µ÷ÓõÄÊÇÔÏÈÓõÄÊý¾Ý¿âÁ¬½ÓµÄÀà¿â£¬¾Í³öÏÖ¸ü¸ß°æ±¾£»ºóÀ´ÎÒ×Ô¼ºÐ´£¬¾Í·¢ÏÖÔÚ·þÎñ³ÌÐòÀïÁ¬½ÓÊý¾Ý¿â¾Í²»ÐÐ Ïà¹ØµÄ·þÎñÓпªÆôô£¿ÒýÓà ÒýÓà 4 Â¥ lvxiao715 µÄ»Ø¸´: ÎÒ¿ªÌûдµÄʱºò£¬µ÷ÓõÄÊÇÔÏÈÓõÄÊý¾Ý¿âÁ¬½ÓµÄÀà¿â£¬¾Í³öÏÖ¸ü¸ß°æ±¾£»ºóÀ´ÎÒ×Ô¼ºÐ´£¬¾Í·¢ÏÖÔÚ·þÎñ³ÌÐòÀïÁ¬½ÓÊý¾Ý¿â¾Í²»ÐÐ Ïà¹ØµÄ·þÎñÓпªÆôô£¿ ×¢²á·þÎñ£¬Æô¶¯ºó£¬°Ñ¸Ã½ø³Ì¸½¼Óµ½vs08Àïµ÷ÊÔ£¬µ½Á¬½ÓÊý¾Ý¿âÊǾÍʧ°ÜÁËÒýÓà ÒýÓà 5 Â¥ tchjl2007 µÄ»Ø¸´: ÒýÓà 4 Â¥ lvxiao715
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä update table_a A set A.flag=1 where A.id in (select B.id from table_b B) ½á¹ûÎóд³É update table_a A set A.flag=1 where ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......