December 2002
Intermediate to advanced
928 pages
85h 29m
English
PL/SQL blocks may span multiple lines and may contain blank lines. They must be terminated by either a forward slash or a period (.) on a line by itself. For example:
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World!');
END;
/
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World!');
END;
.When a forward slash is used, the block is sent to the server and executed immediately. When a period is used, the block is only stored in the SQL buffer. Use the SET BLOCKTERMINATOR command to change the block terminator from a period to some other character.