PL/SQL language basics (1)

PL/SQL language basics (1) a pl/SQL block consists of up to four different parts. Only one part is indispensable. 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 the anonymous block www.2cto.com in addition to the name block. The format is as follows: declare ....... declare part of begin ............. execute partial exception processing end; www.2cto.com 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;