今天测试分页效果用到了Oracle数据库的procedure
下面是sql语句,用的PL SQL
create or replace procedure proc_1(
param_2 in number,
param_1 out number
)
is
var_i number;
begin
for var_i in 1..param_2 loop
insert into studylive values(studyliveids.nextval,22,var_i,var_i,var_i,var_i,var_i);
commit;
end loop;
select count(*) into param_1 from studylive;
end proc_1;