When you use SELECT in a PL/SQL block, it’s ... Oracle’s PL/SQL language has two basic mechanisms for getting data from the database ... name employees.last_name%TYPE; l_employee_full_name ...