|
We now define some PL/SQL variables to reference database entries fetched in previous SELECT command
|
lname person_info_table.last_name%TYPE;
-
-- a variable to hold last name fname person_info_table.first_name%TYPE;
-
-- a variable to hold first name
|
phone phone_list_table.phone_no%TYPE;
-
-- a variable to hold phone no. ptype phone_list_table.phone_type%TYPE;
-
-- a variable to hold phone type
|
|
-- Note format tablename.columnname to
|
|
reference database variables and %TYPE syntax to inherit database type in PL/SQL datatype
|
