036 - [Oracle PL/SQL] Procedure - Default option for Parameters

<샘플코드에서 사용한 데이터는 HR 스키마이고, 오라클 설치시 생성할 수 있는 기본 스키마 입니다>

 

 

 

# using the default value 
# 2 ways for default value ( default value or  := )
create or replace procedure add_products (
    p_prod_id number,
    p_prod_name varchar2:='Ukowun',       --<<<
    p_prod_type  varchar2 default 'Ukowun'--<<<
)
is
begin

    insert into products values (p_prod_id,p_prod_name,p_prod_type);
    commit;

    exception
        when others then
        dbms_output.put_line ('error in insert ');
        dbms_output.put_line (sqlcode);
        dbms_output.put_line (sqlerrm);
end;

execute add_products(10);

select * from products;
----------------------------------------------------------------
   PROD_ID PROD_NAME            PROD_TYPE           
---------- -------------------- --------------------
         1 Laptop               SW                  
         2 PC                   SW                  
         3 Keyboard             HD                  
         4 Windows 10           SW                  
        10 Ukowun               Ukowun