Oracle Report ´íÎó
ÎÒÔÚ×öÒ»¸öReprotʱ£¬ÔÚÆäÖÐдÁËÒ»¸ö¹«Ê½ÓÐselect into Óï¾ä¡£
µ±select Îó¾äÎÞ²éѯµ½¼Ç¼ʱ£¬¾Í³öÏÖ´íÎ󣬿ÉÒÔÓÃexceptionÈ¥´íÎó´¦Àí¡£
µ«ÏÖÔÚÎÒÏëÈñ¨±íÔÚ²éѯµ½Î޼Ǽʱ£¬¾Í²»ÔÙÖ´ÐнÓÏÂÀ´µÄ¶¯×÷£¬¸øÓû§Ìáʾ¡°Î޼Ǽ¡±£¬status²»ÊÇerror,ÊÇnormal
Ó¦ÈçºÎ×ö£¿
¿ÉÊÇÕâÑùµÄ»°£¬Ëü»¹»á¼ÌÐøÖ´ÐÐÏÂÈ¥¡£
±ÈÈç½ÓÏÂÀ´»¹ÈçÆäËüµÄ¹«Ê½µÈ£¬¼°±¨±íµÄÖ÷²éѯ¶¼»áÖ´×Å×ÅÖ´ÐУ¬Æäʵ¶¼ÊÇÎÞÒâÒåµÄ.
ÎÒÏë´Ëʱ¾ÍÖնϱ¨±íµÄÖ´ÐÐÁË¡£
ÄǾͶ¨ÒåÒ»¸öÓ¦ÓóÌÐòÒì³££¬ÔÚexceptionÀï²¶×½µ½no_data_found´íÎóºó£¬Å׳ö¸ÃÒì³£¡£
¾ÍÊDz»ÖªÔõô×öÂï
declare
e_nodata exception;
PRAMGA exception_init(e_nodata,-1403);
begin
...
select ... into ...;
...
exception
when e_nodata then
;--ÄãÏë¸ÉÂ𣬾ÍÔÚÕâ¸ÉÂð£¬Ö»ÒªºÏ·¨¡£
end;
suiziguo,ÎÒ²»ÊÇÒ»¸ö¹«Ê½»òÕß´æ´¢¹ý³Ì£¬ÊÇREPORT£¬Ëù¾ÙµÄÀýÊÇreportÖеÄÒ»¸ö¹«Ê½¡£
ÔÚ´ËʱÎÒÏëÒªÖÕÖ¹±¨±íµÄÖ´ÐУ¬ÇÒ°ÑÔÚ´Ë´¦²¶»ñµÄ´íÎóÐÅÏ¢·µ»Ø¸øÓû§¡£
²»Êǽö¶Ô´Ë¹«Ê½½øÐÐÒì³£´¦Àí¡£
ÓÐÇ¿ÖÆÖÕÖ¹±¨±íÖ´ÐеÄÓï¾äÂð£¿
srw.program_abortÇ¿ÖÆÖÕÖ¹±¨±íµÄÖ´ÐÐ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......