C#²Ù×÷ORACLEÊý¾Ý¿âµÄÎÊÌâ
ÎÊÌâ1£ºÎÒÔÚVS2005ÖÐÒýÓÃusing System.Data.OracleClient;ʱºò±¨´í¡£¡£¡£
ÎÊÌâ2£ºÎÒÈçºÎÁ¬½ÓÊý¾Ý¿â ÈçºÎÔÚC#ÖнøÐÐÔöɾ¸ÄµÄ²Ù×÷¡£
using System.Data.OracleClient;ʱ£¬ÏîÄ¿ÐèÒªÒýÓÃusing System.Data.OracleClient
ÆäËû²Ù×÷ºÍSQLServerÒ»Ñù¡£Á¬½Ó×Ö·û´®¸ñʽ²»Ì«Ò»Ñù¡£²Ù×÷ʲôµÄ×Ô¼º°ÑSQLHelperÅúÁ¿Ìæ»»Ò»ÏÂΪOracleµÄ¾ÍÒ»ÑùÓÃÁË¡£µ±È»SQLÓï¾äÓеã²î±ð¡£
ÎÒµÄVS2005±¨´í°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
ÎÒÖªµÀÒýÓÃÕâ¸ö¡£¡£µ«ÊÇ˵ÕÒ²»µ½ÕâÒýÓÃÊÇÎªÉ¶ÄØ
´íÎó 1 ÃüÃû¿Õ¼ä¡°System.Data¡±Öв»´æÔÚÀàÐÍ»òÃüÃû¿Õ¼äÃû³Æ¡°OracleClient¡±(ÊÇȱÉÙ³ÌÐò¼¯ÒýÓÃÂð?) D:\ÍøÕ¾²É¼¯\SiteAcquisition\SiteAcquisition\Form1.cs 8 19 SiteAcquisition
ÎÒÊÇ˵ÏîÄ¿ÒýÓÃ
ÓÒ¼ü£¬Ìí¼ÓÒýÓᣵÚÒ»¸öÑ¡Ï.netÀѡÉÏSystem.Data.OracleClient
ÄãûÌí¼ÓÒýÓÃ
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
±¾À´ÒªÐ´¸ö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 ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......