oracl procudure 기초자료1

신입디비교육자료 만들면서 나도 이기회에 정리~

 

기초 LEVEL1----------------------------

 

create or replace procedure p_test

is

V_age tb_user.AGE%type;

begin

  select AGE into V_age

  from tb_user

  where USER_ID='bradpitt';

  dbms_output.put_line('bradpitt 나이= '|| V_age );

end;

 

 

기초 LEVEL2----------------------------

 

create or replace procedure p_test1

is

V_age VARCHAR2(10):=''; 

begin

  select AGE into V_age

  from tb_user

  where USER_ID='tomcrus7';

  dbms_output.put_line('tomcrus7 나이= '|| V_age );

end;

 

기초 LEVEL3----------------------------

 

create or replace procedure p_test2 (

  V_USER_ID IN VARCHAR2

)

is

V_age VARCHAR2(10):=''; 

begin

  select AGE into V_age

  from tb_user

  where USER_ID = V_USER_ID;

  dbms_output.put_line(V_USER_ID || '의 나이= '|| V_age );

end;

 

기초 LEVEL4----------------------------

 

create or replace procedure p_test3 

is

   V_TITLE VARCHAR2(10):='procedure';

   V_content VARCHAR2(1):= 'M';

   V_name VARCHAR2(10):= '77';

begin

   insert into tb_user(USER_ID, USER_TYPE, AGE)

   values (V_TITLE, V_content, V_name);

end;