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