Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ibatis²éѯoracle·ÖÒ³ÅäÖÃ

×î½ü×öÒ»¸öjavaÏîÄ¿£¬Ê¹ÓÃibatisÓëÊý¾Ý¿âÁ¬½Ó£¬ÎÒÏÖÔÚÖªµÀÔÚmysqlÊý¾Ý¿âµÄʱºò£¬ÅäÖÃsql·ÖÒ³ÊÇÓÃ
XML code:

<sql id="pageSql">
<dynamic>
<isNotNull property="startIndex">
<isNotNull property="pageSize">
limit #startIndex# , #pageSize#
</isNotNull>
</isNotNull>
</dynamic>
</sql>



ÎÒÏÖÔÚÓõÄÊÇoracleÊý¾Ý¿â£¬ÇëÎÊÓ¦¸ÃÔõôÅäÖÃÕâ¸ö·Öҳѽ£¿
×Ô¼º½â¾öÁË£¬ºÇºÇ

Ìù³öÀ´¿´¿´

select * from (select rownum as minRownum, u.* from ( select * from user)
) u
<dynamic prepend="where">
    <isGreaterThan prepend="and" property="maxRownum" compareValue="0">
<![CDATA[ rownum <=#maxRownum# ]]>
    </isGreaterThan>
</dynamic>
  ) t where
<![CDATA[t.minRownum>#minRownum#]]>

¹§Ï²Ò»Ï£¬°Ñ½â¾ö·½·¨Ìù³öÀ´·ÖÏíÒ»ÏÂ

XML code:

[code=XML]
<sql id="paginationStart">select b.* from (select a.*,rownum as linenum from (</sql>
- <sql id="paginationEnd">
- <dynamic>
- <isNotNull property="startIndex&


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿

´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺

δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ