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×é¼þ½øÐзÃÎÊ,²»ÓÐÎÊÌâµÄ
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......