create or replace function (p_emp_no in VARCHAR2) return is
Result emp%ROWTYPE;
rec_emp emp%ROWTYPE;
begin
SELECT *
INTO rec_emp
FROM emp;
dbms_output.put_line('emp_no:'||rec_emp.number);
dbms_output.put_line('emp_name:'||rec_emp.name);
return(rec_emp);
end ;
温馨提示:答案为网友推荐,仅供参考