Sunday, 12 July 2015

how to display the emp details by using function

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;

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...