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

C#Á¬½ÓoracleµÄÖÐÎÄÏÔʾÎÊÌâ

ÒýÓÃ

using System.Data.OracleClient;

oracleµÄÓï¾äÈçÏ£º

OracleDataAdapter oda2 = new OracleDataAdapter(" select '¹þ¹þ:'||trunc(sum(dr)/10000)||' ¹þ¹þ:'||trunc(sum(dy)/10000)||' ¹þ¹þ:'||trunc(sum(jl)/10000) memo from a_xs_all where rq=trunc(sysdate) ", conn);

ÏÔʾ²»ÁËÖÐÎÄ£¬µ«ÊÇÓÃPB²éÊÇÕý³£µÄ


http://www.cnblogs.com/land/archive/2009/08/17/1548120.html
²»°²×°Oracle10g¿Í»§¶ËÁ¬½ÓOracle10gÊý¾Ý¿â,ÉèÖñàÂë¸ñʽ

ÎÊÌâÊDz»°²×°µÄ»°ºÜÂé·³µÄ£¬ºÜ¶à¶«Î÷¶¼Óò»Á˵Ä

ÄãÑ¡ÔñµÄÁ¬½Ó×é¼þÓÐÎÊÌâ,OracleÉý¼¶ºÜ¿ì,Äã×îºÃÑ¡Oracle¹«Ë¾µÄODAC×é¼þ½øÐзÃÎÊ,²»ÓÐÎÊÌâµÄ


Ïà¹ØÎÊ´ð£º

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

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

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ