create or replace procedure myprocedure0813 as i integer; begin for i in 1..10 loop insert into mytable0813(id,name,age) values(i,'ysy'||i,i); end loop; commit;end;
方法一:
exec procedure_name;
execute procedure_name;
方法二:
call procedure_name;
方法三:
begin
execute procedure_name;end;
end;
exec mdx :a,:b,:c
执行oracle的存储过程
最新推荐文章于 2024-06-05 16:17:52 发布