ࡱ > 9 R g bjbj 2$ @; ( M l ^ ^ ^ r h? h? h? 8 ? \@ r dB . E ( E E E zG U T Y , $ ! A l ^ \ TG XG " \ \ u E E է u u u \ 8 E R E u \ u H u { V < " E XB yr 7 h? h r " < 0 nr d u r r P L / S Q L V S . T R A N S A C T S Q L F{ T O C \ o " 1 - 3 " \ h \ z H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 4 0 " 1 . N/fP L / S Q L P A G E R E F _ T o c 6 6 1 7 2 9 4 0 \ h 2 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 4 1 " 2 . P L / S Q L T R A N S C A S Q L k P A G E R E F _ T o c 6 6 1 7 2 9 4 1 \ h 2 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 4 2 " @SJXh:yB E G I N END;/ PAGEREF _Toc66172942 \h 2 HYPERLINK \l "_Toc66172943" DECLARE PAGEREF _Toc66172943 \h 2 HYPERLINK \l "_Toc66172944" OPERATOR PAGEREF _Toc66172944 \h 2 HYPERLINK \l "_Toc66172945" CONDITIONAL CONTROL PAGEREF _Toc66172945 \h 3 HYPERLINK \l "_Toc66172946" PROCEDURE PAGEREF _Toc66172946 \h 5 HYPERLINK \l "_Toc66172947" FUNCTION PAGEREF _Toc66172947 \h 6 HYPERLINK \l "_Toc66172948" PACKAGE(PL/SQL) PAGEREF _Toc66172948 \h 7 HYPERLINK \l " _ T o c 6 6 1 7 2 9 4 9 " E X C E P T I O N ( P L / S Q L ) P A G E R E F _ T o c 6 6 1 7 2 9 4 9 \ h 7 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 0 " % T Y P E 0% R O W T Y P E A T T R I B U T E ( P L / S Q L ) P A G E R E F _ T o c 6 6 1 7 2 9 5 0 \ h 8 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 1 " S E L E C T & I N T O P A G E R E F _ T o c 6 6 1 7 2 9 5 1 \ h 9 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 2 " C U R S O R P A G E R E F _ T o c 6 6 1 7 2 9 5 2 \ h 1 0 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 3 " S E Q U E N C T P A G E R E F _ T o c 6 6 1 7 2 9 5 3 \ h 1 1 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 4 " T R A N S A C T I O N P R O C E S S I N G P A G E R E F _ T o c 6 6 1 7 2 9 5 4 \ h 1 1 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 5 " 3 . P; P A G E R E F _ T o c 6 6 1 7 2 9 5 5 \ h 1 2 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 6 " N/f S Q L ? P A G E R E F _ T o c 6 6 1 7 2 9 5 6 \ h 1 2 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 7 " S Q L vRR^ P A G E R E F _ T o c 6 6 1 7 2 9 5 7 \ h 1 3 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 8 " T r a n s a c t - S Q L P A G E R E F _ T o c 6 6 1 7 2 9 5 8 \ h 1 3 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 5 9 " R E F E R E N C E P A G E R E F _ T o c 6 6 1 7 2 9 5 9 \ h 1 3 H Y P E R L I N K \ l " _ T o c 6 6 1 7 2 9 6 0 " N'Ynje^{t|q}KNk=~h P A G E R E F _ T o c 6 6 1 7 2 9 6 0 \ h 1 3 F{Wݑ \P L / S Q L T R A N S A C T S Q L ( M S S Q L ) vk/fN NPP L / S Q L Rx[vޞk_N1 g Ywckvm\ Nfw\ˊTMOHQ2Smcck0vQ(uaCN\Op g NeKNWyS`x[S NeKNS0 N/fP L / S Q L P L / S Q L /fO R A C L E ^8OS Q L - 9 2 _O(ueO R A C L E D A T A B A S E vS Q L 0XRNAmzc6Rvl0 P L / S Q L T R A N S A C T S Q L k @SJXh:yB E G I N & E N D ; / O R A C L E M S S Q L _ne B E G I N . . . E N D ; / @SJX k NcN_NR_P}>\ S E T S E R V E R O U T P U T O N D E C L A R E A A V A R C H A R 2 ( 1 0 0 ) ; B E G I N A A : = ' L K K ' ; D B M S _ O U T P U T . P U T _ L I N E ( A A ) ; E N D ; / !q@SR( !qyr%Rh:y) D E C L A R E @ A A A S V A R C H A R ( 1 0 0 ) S E T @ A A = ' L K K ' S E L E C T @ A A D E C L A R E O R A C L E M S S Q L D E C L A R E m N o N U M B E R ; m N a m e V A R C H A R 2 ( 1 0 0 ) ; _NNܕuW[@ - D E C L A R E @ A A A S V A R C H A R ( 1 0 0 ) , @ B B I N T O P E R A T O R O R A C L E M S S Q L nj2NP}TO(uܕuW[| | D E C L A R E m N a m e V A R C H A R 2 ( 1 0 0 ) ; b e g i n D B M S _ O U T P U T . P U T _ L I N E ( '