¹«Ë¾ÓиöÏîÄ¿ÊÇÓõÄORACLEµç×ÓÉÌÎñÌ×¼þ.Ó¦Ó÷þÎñÆ÷ÓõÄÊÇORACLE AS ¡£ÔÚÏîÄ¿ÒýÈëµ½JAR°üÖÐÓÐÒ»¸öORACLE.JAR ¡£
µ«ÊÇÕâ¸öORACLE.JAR ÓÐ90¶àMB¡£ ÀïÃæ·â×°ÁËһЩºÍÊý¾Ý¿âÁ¬½ÓÏà¹ØµÄ¶«Î÷¡£±ÈÈ磺ÓжÔsessionµÄ·â×°µÈ¡£
µ«ÊÇÎÒÓÃJDEVELOPER ²é¿´Äܹ»¿´µ½Ò»Ð©½Ó¿ÚµÄÎļþ¡£¾ßÌåʵÏÖ¿´²»µ½£¬Ó¦¸ÃÊÇJDEVELOPER¼¯³ÉÁË»ù±¾µÄORA ......
ÅäÖÃÎļþ£º
XML code:
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property>
<prope ......
ÎÒÊÇÐÂÈË£¬½«ORACLEÊý¾Ý¿âÉèΪֻ¶Á ÃüÁîÊÇ£ºalter database read only£»
µ«ÊÇÔÚsqlplusÖÐÖ´ÐдËÃüÁîµÄʱºòÓÖ±¨´í£¡ÕâÊÇÎªÊ²Ã´ÄØ£¿ Ï£Íû¸ßÊÖ½â´ðһϣ¡
Â¥Ö÷¿´ÏÂÕâÆªÎÄÕÂ
ÃüÁîÓ¦¸ÃÊÇ£ºalter database open read only
http://blog.chinaunix.net/u/23045/showart_382080.html
Ä ......
Çë½Ì¸÷λ ÎÒдÁËÒ»¸ö·ÖÒ³µÄ´æ´¢¹ý³Ì ÈçÏÂ
create or replace procedure PP(currpage in number,pagesize in number)
as
begin
select * from (select rownum as rid,emp.* from emp where rownum <=currpage*pagesize)t where t.rid>(currpage-1)*pagesize;
end PP;
¹ý³Ì¿ÉÒÔ´´½ ......
ÔÚoracleÖÐÈçºÎ½«varcharÀàÐÍת»»³ÉrawÀàÐÍ
ÒýÓÃ
UTL_RAW.CAST_TO_RAW(value)
ÁíÍâ,oracleÍÆ¼övarchar2
Ã²ËÆoracleÍÆ¼öCLOB£¬ºÇºÇ¡£
ºÇºÇ ÊÔÏ£¡
ÒýÓÃ
Ã²ËÆoracleÍÆ¼öCLOB£¬ºÇºÇ¡£
Îó»á£¬ºÇºÇ£¬Ïà±Èvarchar£¬oracleÍÆ¼övarchar2
......
ÎÒÊÇÏëʵÏÖÕâÑùµÄ£º
Á½¸öÓαêcurosr1¡¢cursor2·Ö±ðÊDzéѯÁ½ÕŲ»Í¬µÄ±ítab1£¬tab2£¨¶¼ÓÐÏàͬµÄÁ½¸ö·ÇÖ÷¼ü×ֶΣº'ÉÌÆ·ID'ºÍ'ÊýÁ¿'£©¡£ÎÒÓÃǶÌ×loop·Ö±ðÑ»·tab1ºÍtab2£¬Èôcurosr1µÄµ±Ç°ÁÐÓëcursor2µ±Ç°ÁÐÂú×ãijÖÖÌõ¼þ£¨±ÈÈç¶Î'ÉÌÆ·ID'Ïàͬ£©£¬ÔòÐÞ¸Äcurosr1µ±Ç°ÁеÄ'ÊýÁ¿'£¨µ«²»ÐÞ¸ÄÊý¾Ý¿ ......