CODE EXAMPLE FOR SQL

oracle select into

SELECT NAME, ADDRESS, PHONE
INTO v_employee_name, v_employee_address, v_employee_phone_number
FROM EMPLOYEE
WHERE EMPLOYYE_ID = 6;