DECLARE
 emp_record employee%ROWTYPE;
 sql_stat VARCHAR2(100);
begin
 sql_stat:='SELECT * FROM employee WHERE employeeno=:eno';
 EXECUTE IMMEDIATE sql_stat INTO emp_record USING &1;
 dbms_output.put_line('雇員：'||emp_record.employeename||'的工資為：'||emp_record.sal);
END;
/