EXECUTION SECTION OF PL/SQL

NO1. The general struture of execution section is :

 NO2.expresstion:

        PL/SQL exceptions consists of one or more PL/SQL variables conbined one or more PL/SQL operators .An exception may appear in one of the following locations:

 

      1.On the right side of the assignment statement ;

      2.As part of control statement ;

      3.As part of SQL ;

NO3.control statement :

      1.IF-THEN-ELSE

       IF experssion THEN

           statement ;[statemetn ;...]

        [ELSIF  expression THEN

           statement ;[statemetn ;...]

        ]

        [ELSE

           statement ;[statemetn ;...]

        ]

        END IF ;

      2.LOOP

      LOOP

          [EXIT;]

          [EXIT WHEN contition;]

          statement ;[statement ; ...]

      END LOOP;

     3.WHILE-LOOP-END LOOP

     4.FOR count IN [RESERVE] start ... end LOOP

             statement ;[statement ;...]

       END LOOP ;

     5.GOTO

     6.NULL