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

C#²Ù×÷ORACLEÊý¾Ý¿âµÄÎÊÌâ

ÎÊÌâ1£ºÎÒÔÚVS2005ÖÐÒýÓÃusing System.Data.OracleClient;ʱºò±¨´í¡£¡£¡£

ÎÊÌâ2£ºÎÒÈçºÎÁ¬½ÓÊý¾Ý¿â ÈçºÎÔÚC#ÖнøÐÐÔöɾ¸ÄµÄ²Ù×÷¡£
using System.Data.OracleClient;ʱ£¬ÏîÄ¿ÐèÒªÒýÓÃusing System.Data.OracleClient

ÆäËû²Ù×÷ºÍSQLServerÒ»Ñù¡£Á¬½Ó×Ö·û´®¸ñʽ²»Ì«Ò»Ñù¡£²Ù×÷ʲôµÄ×Ô¼º°ÑSQLHelperÅúÁ¿Ìæ»»Ò»ÏÂΪOracleµÄ¾ÍÒ»ÑùÓÃÁË¡£µ±È»SQLÓï¾äÓеã²î±ð¡£

ÒýÓÃ
using System.Data.OracleClient;ʱ£¬ÏîÄ¿ÐèÒªÒýÓÃusing System.Data.OracleClient


ÎÒµÄVS2005±¨´í°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
ÎÒÖªµÀÒýÓÃÕâ¸ö¡£¡£µ«ÊÇ˵ÕÒ²»µ½ÕâÒýÓÃÊÇÎªÉ¶ÄØ

´íÎó 1 ÃüÃû¿Õ¼ä¡°System.Data¡±Öв»´æÔÚÀàÐÍ»òÃüÃû¿Õ¼äÃû³Æ¡°OracleClient¡±(ÊÇȱÉÙ³ÌÐò¼¯ÒýÓÃÂð?) D:\ÍøÕ¾²É¼¯\SiteAcquisition\SiteAcquisition\Form1.cs 8 19 SiteAcquisition


ÎÒÊÇ˵ÏîÄ¿ÒýÓÃ
ÓÒ¼ü£¬Ìí¼ÓÒýÓᣵÚÒ»¸öÑ¡Ï.netÀѡÉÏSystem.Data.OracleClient

ÄãûÌí¼ÓÒýÓÃ


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÊÇ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 ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

¼±ÇóASP¡£NETC#¹ºÎï³µ´úÂë

×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡

www.51aspx.com

ȥϠ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ