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

C#Öе÷ÓÃOracle´æ´¢¹ý³Ì


¿Í»§»·¾³£ºVS2008+Oracle9i
·þÎñÆ÷Êý¾Ý¿â£ºOracle9i
Óöµ½Ò»¸öÎÊÌâ:¿Í»§¶Ë³ÌÐòÖÐÒªµ÷Ó÷þÎñÆ÷ÉϵĴ洢¹ý³Ì¡£ÎÒʹÓÃADO.NETµ÷ÓÃʱϵͳÌáʾ²ÎÊýÀàÐÍ»òÕß²ÎÊý¸öÊý²»ÕýÈ·¡£ÎÒ¼ì²éÒÔºóûÓз¢ÏÖÀàÐÍ´íÎó»òÕß²ÎÊý¸öÊý²»¶Ô¡£
ÓÚÊÇʹÓÃOracleµÄODAC×é¼þ£¨°æ±¾ºÅ-ODP.NET 9.2.0.7.00 £©µ÷ÓÃÒ²ÌáʾÓдíÎó¡£
ÒòΪ×öµ÷ÊÔµÄʱºò£¬»úÆ÷ÉÏ×°µÄÊÇoracle10g¿Í»§¶Ë,µ«ÎÒ³ÌÐòÀïÒýÓõÄdllÊÇOracle9iµÄ¡£Ê²Ã´Ô­ÒòÄØ£¿
ÏÖÔÚÓÖ¼¸µã²»Ã÷°×£º
1¡¢ÔÚʹÓÃADO.NETµ÷ÓÃOracle´æ´¢¹ý³ÌʱΪʲô³öÏÖ¡°²ÎÊýÀàÐÍ»òÕß²ÎÊý¸öÊý²»ÕýÈ·¡±Ìáʾ¡£
2¡¢Èç¹û»úÆ÷ÉÏͬʱװÓÐOracle10g¿Í»§¶ËºÍODP.NET 9.2.0.7.00·ÃÎÊ×é¼þ£¬¶Ô³ÌÐòÖе÷Óô洢¹ý³ÌÓÐûÓÐʲôӰÏì¡£
3¡¢»¹ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÉÏÊöÎÊÌâ¡£
Ã÷°×µÄÐÖµÜÃǰï°ï棡
ÎÒÊǰɿͻ§¶Ëɾ³ýÁË£¬ÓõÄODAC 11GµÄ°æ±¾

´æ´¢¹ý³ÌÄÇÎÊÌâ²»Çå³þ

´æ´¢¹ý³ÌÖØÐ±àÒëÏ¡£¡£¶à°ë»¹ÊDzÎÊý²»ÕýÈ·£¬ÖðÒ»¼ì²é°É¡£

°æ±¾²»Ò»ÖÂ
¿Í»§¶ËÒª°²×°

³ÌÐòÖеIJÎÊýºÍ´æ´¢¹ý³ÌÖеIJÎÊýÃûÊÇÒªÒ»ÑùµÄ


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

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

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

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

¸ß·ÖÇë½Ì oracle Òì³£µÄ²¶»ñÎÊÌâ

ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog  "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"

TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ