PL/SQL PACKAGE

PL/SQL  PACKAGE 

 

 사용방법을 예제로 배워보자!

 

- getEmpName, getDeptName 함수 두개를 NAMES 패키지에 담는다

 

create or replace package names as

    function getempname(p_empno emp.empno%type) return varchar2;
    
    function getdeptname(p_deptno dept.deptno%type) return varchar2;
    
end names;
/

create or replace package body names as

    function getdeptname(p_deptno dept.deptno%type) return varchar2 as
    
        v_dname dept.dname%type;
        
    begin
    
        select dname into v_dname
        
        from dept
        
        where deptno = p_deptno;
        
        
        return v_dname;
        
    end;
    
    function getEmpName (p_empno emp.empno%type) return varchar2 is
    
        v_ename emp.ename%type;
        
    begin
    
        select ename into v_ename
        
        from emp
        
        where emp.empno = p_empno;
    
        return v_ename;
        
    end;
end;
/