	DECLARE
		rec_Ename		EMPLOYEES.FIRST_NAME%TYPE;
		rec_Hiredate	EMPLOYEES.HIRE_DATE%TYPE;
		rec_Sal			EMPLOYEES.SALARY%TYPE;
		rec_Comm		EMPLOYEES.COMMISSION_PCT%TYPE;

	BEGIN
		SELECT FIRST_NAME, HIRE_DATE, SALARY, COMMISSION_PCT  INTO 
		rec_Ename, rec_Hiredate, rec_Sal, rec_Comm FROM EMPLOYEES
		WHERE EMPLOYEE_ID = &EMPLOYEE_ID;
			
		DBMS_OUTPUT.PUT_LINE('Employee First Name:  ' || rec_Ename);
		DBMS_OUTPUT.PUT_LINE('---------------------------------');
		DBMS_OUTPUT.PUT_LINE('Employee Join Date:  ' ||rec_Hiredate);
		DBMS_OUTPUT.PUT_LINE('---------------------------------');
		DBMS_OUTPUT.PUT_LINE('Employee Salary:     ' || rec_Sal);
		DBMS_OUTPUT.PUT_LINE('---------------------------------');
		DBMS_OUTPUT.PUT_LINE('Employee Commission: ' || rec_Comm);
	END;