練習(xí)代碼如下

create or replace PROCEDURE prodemo(param1 in VARCHAR2)?

as?

? ageTemp "student".age%type;

begin

? select age into ageTemp from "student" where id=param1;

? update "student" set age=age+1 where id=param1;

? dbms_output.put_line('去年的年齡是:' ||ageTemp|| ',今年的年齡是:' ||(ageTemp+1));?

? end;