AspxÓëoracleÖ®¼äµÄÁ¬½ÓÎÊÌâ
¸÷λ¸ßÊÖ¡£¡£±¾ÈËÓöµ½Ò»¸öÎÊÌ⣬·Ç³£µÄ¹ÖÒ죺
ÎÒ¿ª·¢ÁËÒ»¸ö¾ºÅĵÄÍøÕ¾¡£ÔÚvs2005 ÉϲâÊÔÍêȫûÓÐÎÊÌâ¡£µ«ÊÇ·¢²¼³öÀ´µÄ´úÂëÔÚiis Öеķ¢²¼Ëý±¨³öÁËÊý¾Ý¿âÁ¬½Óʧ°Ü£¿
µ«ÊÇÎÒÕâÌ×Êý¾Ý¿âÁ¬½Ó£¬ÎÒÒÔǰÓùýÍêȫûÓÐÎÊÌâ°¡£¿£¿
¸÷λ´ó¸çÖ¸µãÒ»ÏÂСµÜ£º
Êý¾Ý¿âÁ¬½Ó·û£ºData Source=Data;Persist Security Info=True;User ID=outln;Password=123;Unicode=True
´úÂë:
C# code:
OracleConnection Conn = GetSqlConnection("Á¬½Ó·û");
string CommTxt="sql Óï¾ä";
cmd.CommandText = CommTxt;
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
Conn.Open();--------------------¡·¡·¾ÍÊÇÔÚ´ò¿ªÁ¬½ÓµÄʱºò³ö´íµÄ
OracleTransaction Tran = Conn.BeginTransaction();
cmd.Transaction = Tran;
try
{
rInt = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception ex)
{
}
ûÓÐÈËÖªµÀÂ𣿣¿¸÷λ¸øµãÌáʾ£¡£¡
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Exception: OCIEnvCreate ʧ°Ü£¬·µ»Ø´úÂëΪ -1£¬µ«´íÎóÏûÏ¢Îı¾²»¿ÉÓá£
Ô´´íÎó:
ÐÐ 2685: sb.AppendFormat("SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from {0} {1} {2}) A WHERE ROWN
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......