oracle中字符串连接用||
create or replace procedure testIf(idid number) is v_name stu.name%type; v_age stu.age%type; begin if idid = 1 then update stu set age = age*2 where id = idid; select age into v_age from stu where id = idid; dbms_output.put_line('age'||v_age);--oracle中字符串连接用|| elsif idid = 3 then update stu set name = 'shitailong' where id = idid; select name into v_name from stu where id = idid; --oracle中的字符串连接用|| dbms_output.put_line('name'||v_name); else update stu set age = age*3 where id = idid; select age into v_age from stu where id = idid; dbms_output.put_line('age'||v_age); end if; end;