PL/SQL块结构

PL/SQL块结构：

        PL/SQL块由三个部分组成：定义部分、执行部分、例外处理部分。

        

        基本结构如下所示：

                DECLARE

                /*

                *    定义部分——定义常量、变量、复杂数据类型、游标、例解

                */

                BEGIN

                 /*

                *    执行部分——PL/SQL和SQL语句

                */

                EXCEPTION

                 /*

                *    例外处理部分——处理运行错误

                */

                END;

        例:

                DECLARE

                    v_name VARCHAR2(10);

                BEGIN

                        SELECT ename INTO v_name FROM emp

                    WHERE empno = &no;

                        dbms_output.put_line('雇员名:'||v_name);

                EXCEPTION

                    WHERE NO_DATA_FOUND    THEN

                        dbms_output.put_line('请输入正确的雇员号！');       

                END;