Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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:
......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

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

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

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ