Chapter 8, Problem 11RQ

Explanation of Solution

Placing the results of a “SELECT” command into variables:

• To place the results of a “SELECT” command into variables, “INTO” clause is used.
• It can hold different set of variables and places the result in the corresponding variables.

Example:

/*Create a procedure*/

CREATE OR REPLACE PROCEDURE DISP_REP_NAME (I_REP_NAME IN REP.REF_NUM%TYPE) AS

/*Declaring the local variable*/

I_LASI_NAME REP.LAST_NAME%TYPE ;

I_FIRST_NAME REP...