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×é¼þ½øÐзÃÎÊ,²»ÓÐÎÊÌâµÄ
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.co ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......