create or replace type emp_type as object(empno number(10)
,sal number(10)
,deptno number(10)
,comm number(10)
,mgr number(10)
,hiredate date
,ename varchar2(100)
,job varchar2(100));
create or replace function emp_fun(empno number
,sal number
,deptno number
,comm number
,mgr number
,hiredate date
,ename varchar2
,job varchar2)
return emp_type as
o_emp_type emp_type;
begin
o_emp_type:=emp_type(empno,sal,deptno,comm,mgr,hiredate,ename,job);
return o_emp_type;
end;
select emp_fun(empno,sal,deptno,comm,mgr,hiredate,ename,job) from emp where empno=&p_empno;
,sal number(10)
,deptno number(10)
,comm number(10)
,mgr number(10)
,hiredate date
,ename varchar2(100)
,job varchar2(100));
create or replace function emp_fun(empno number
,sal number
,deptno number
,comm number
,mgr number
,hiredate date
,ename varchar2
,job varchar2)
return emp_type as
o_emp_type emp_type;
begin
o_emp_type:=emp_type(empno,sal,deptno,comm,mgr,hiredate,ename,job);
return o_emp_type;
end;
select emp_fun(empno,sal,deptno,comm,mgr,hiredate,ename,job) from emp where empno=&p_empno;
No comments:
Post a Comment