After this Lab, you will be able to:
In PL/SQL, there are two main methods of giving value to variables in a PL/SQL block. The first one, which you learned in Chapter 2, “PL/SQL Concepts,” is initialization with the “:=” syntax. In this lab we will learn how to initialize a variable with a select statement by making use of SELECT INTO syntax.
A variable that has been declared in the declaration section of the PL/SQL block can later be given a value with a SELECT statement. The correct syntax is as follows:
SELECT item_name ...