Oracle Advanced PL/SQL Developer Professional Guide

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "The SERVEROUTPUT parameter is a SQL*Plus variable which enables the printing of block debug messages."

A block of code is set as follows:

/*Start the PL/SQL block*/
DECLARE

/*Declare a local variable and initialize with a default value*/
   L_NUM NUMBER := 15;
   L_RES NUMBER;
BEGIN

/*Calculate the double of local variable*/
L_RES := L_NUM *2;

/*Print the result*/
   DBMS_OUTPUT.PUT_LINE('Double of '||TO_CHAR(L_NUM)||' is '||TO_
CHAR(L_RES));
END;
/
Double of 15 is 30

PL/SQL procedure successfully completed.

When we wish ...