--创建表
create table users(id number primary key,name varchar2(20));
--创建一个存储过程,循环往users表里面添加十条记录,while循环
create or replace procedure sp_pro3(names varchar2) is
nums number :=1;
begin
while nums<=10 loop
insert into users values(nums,names);
nums:=nums+1;
end loop;
end;
--创建表
create table users(id number primary key,name varchar2(20));
--创建一个存储过程,循环往users表里面添加十条记录,loop,end loop 循环
create or replace procedure sp_pro3(names varchar2) is
nums number :=1;
begin
loop
insert into users values(nums,names);
exit when nums>10;
nums:=nums+1;
end loop;
end;
--创建表
create table users(id number primary key,name varchar2(20));
--创建一个存储过程,循环往users表里面添加十条记录,for 循环
create or replace procedure sp_pro3(names varchar2) is
begin
for i in reverse 1..10 loop
insert into users values(i,names);
end loop;
end;