Oracle/PL/SQL

15일차 # 1-17

Bohemian life 2012. 4. 24. 22:05

create or replace procedure up_mode (

 a in     number

, b out    number

  , c in out number

)

is

 v number;

begin

 v := a; 

--  a := 100;  --> expression 'A' cannot be used as an assignment target


 v := b;

 b := 100;


 v := c;

 c := 100;


 b := a*0.12;

 c := c*0.12;

end;

/



declare

 v1 number := 100;

 v2 number := 100;

 v3 number := 200;

begin

 up_mode(v1, v2, v3);

 p(v1||' '||v2||' '||v3);

end;

/