| 1 |
We now define some PL/SQL variables to reference database entries fetched in previous SELECT command
|
| 2 |
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
|
| 3 |
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
|
| 4 |
-- Note format tablename.columnname to
|
| 5 |
reference database variables and %TYPE syntax to inherit database type in PL/SQL datatype
|
