Basic PL/SQL language

Based on PL/SQL, a pl/SQL block consists of up to four different parts. Only one part is required. block: only named blocks are available, that is, the named functions, stored procedures, and other block names. declaration part: defines variables, cursors, and references. execution part: an indispensable part of the statement to be executed during running. 4. exception Handling part: the exception prompt thrown during normal processing. The error message pl/SQL contains anonymous block in addition to the name block: the block with no name. The format is as follows: declare ....... declare part of begin ............. execute partial exception www.2cto.com exception Handling end; simple anonymous block example: declare empname varchar (20); begin select ename into empname from scott. emp where rownum <2; dbms_output.put_line (empname); exception when VALUE_ERROR THEN dbms_output.put_line ('SQL is not right'); end; author Eric_ho