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;
/