C#ÓëORACLE³ÌÐòÎÊÌâ(ÔÚÏßµÈ)¡£
StringBuilder yzb3 = new StringBuilder();
yzb2.Append("select count(device) as j from temp_a ");
DbHelperSQL.ExecuteSimpleSql(yzb3.ToString());
ÎÒÏë°Ñj×÷Ϊ±äÁ¿ÔÚ³ÌÐòÖÐʹÓá£Ó¦¸ÃÔõô×ö¡£
ÐèÇóûÓÐ˵Ã÷Çå³þ£¬jÊÇÒª¶¯Ì¬´«È룿»¹ÊÇÆäËüÒâ˼
ÄãµÃÔÚ³ÌÐòÖж¨ÒåÒ»¸öDATASET½ÓÊÕ·µ»ØµÄ½á¹û¼¯ºÍ,È»ºó¾Í¿ÉÒÔ°ÑDATASETÀïµÄJ×ֶθ³Öµ¸øÄãµÄ³ÌÐò±äÁ¿,ÕâÑù¿ÉÒÔʹÓÃÁË
ÄãµÃÔÚ³ÌÐòÖж¨ÒåÒ»¸öDATASET½ÓÊÕ·µ»ØµÄ½á¹û¼¯ºÍ,È»ºó¾Í¿ÉÒÔ°ÑDATASETÀïµÄJ×ֶθ³Öµ¸øÄãµÄ³ÌÐò±äÁ¿,ÕâÑù¿ÉÒÔʹÓÃÁË
Õý½â
лл´ó¼Ò¡£ÎÒ×Ô¼º´ÓͼÊé¹Ý½èÁ˱¾ÊéÀ´¿´¡£ÆäʵÕâ¸ö¶«Î÷ÿ¸öÈ˶¼ÓÐÿ¸öÈ˵Äʵ¼ÊÇé¿ö£¬Ïë·¨²»Ò»Ñù£¬Ë¼Â·¾Í²»Ò»Ñù¡£ÎÒ½áÌùÁË¡£Ð»Ð»´ó¼Ò¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......