Oracle/PL/SQL
15일차 # 4-7
Bohemian life
2012. 4. 24. 22:13
create or replace function to_char(a number) return varchar2
is
begin
return a ||'입니다';
end;
/
col ret format a20
select empno, sal, to_char(sal), java30.to_char(sal) as ret
from emp;
-----------------
create or replace package pack_overloading
is
procedure print(a number);
end;
/
create or replace package body pack_overloading
is
function to_char(a number) return varchar2
is
begin
return a ||'입니다';
end;
procedure print(a number)
is
begin
p(to_char(a));
p(standard.to_char(a));
end;
end;
/
set serveroutput on
exec pack_overloading.print(1000)