15일차 # 4-7

  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)