DECLARE
	Emp_Rec EMPLOYEES%ROWTYPE;

BEGIN
	SELECT * INTO Emp_REC FROM EMPLOYEES
	WHERE EMPLOYEE_ID = &EMPLOYEE_ID;
			
	DBMS_OUTPUT.PUT_LINE('Employee Name:  ' || Emp_Rec.FIRST_NAME || ' ' || Emp_Rec .LAST_NAME);
	DBMS_OUTPUT.PUT_LINE('---------------------------------');
	DBMS_OUTPUT.PUT_LINE('Employee Join Date:  ' || Emp_Rec.HIRE_DATE);
	DBMS_OUTPUT.PUT_LINE('---------------------------------');
	DBMS_OUTPUT.PUT_LINE('Employee Salary:  '||Emp_Rec.SALARY);
	DBMS_OUTPUT.PUT_LINE('---------------------------------');
	DBMS_OUTPUT.PUT_LINE('Employee Commission: ' || Emp_Rec.COMMISSION_PCT);
END;
