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

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


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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ÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ