Oracle/PL/SQL

PL/SQL Block Structure

Figo Kim 2006. 12. 31. 05:06
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

DECLARE (Optional)

    Variables, cursors, user-defined exceptions

BEGIN (Mandatory)

- SQL Statements

- PL/SQL statements

EXCEPTION

    Actions to perform when errors occur

END; (Mandatory)

** The END block is terminated with a semicolon.

'Oracle > PL/SQL' 카테고리의 다른 글

Create a sample Anonymous block  (0) 2006.12.31
Create a sample Anonymous block  (0) 2006.12.31
Block Types  (0) 2006.12.31
Block Types  (0) 2006.12.31
PL/SQL Block Structure  (0) 2006.12.31