可以的,请看我下面的例子:create procedure proc2() asbegin declare cnt int :=0; select count(*) into cnt from t2; insert into t2 values (:cnt);end
显示全部可以的,请看我下面的例子:
create procedure proc2() as
begin
declare cnt int :=0;
select count(*) into cnt from t2;
insert into t2 values (:cnt);
end
收起