Oracle 控制语句

最新推荐文章于 2025-08-09 18:20:04 发布

weixin_33701617

最新推荐文章于 2025-08-09 18:20:04 发布

阅读量73

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/gzh4455/archive/2012/06/12/2546876.html

1. 定义变量

declare n integer; //定义单个变量
//定义多个变量
DECLARE
 n integer;
mm integer;

2. 赋值

n:=12;
mm:=100;

for 语句

DECLARE
n integer;
mm integer;
begin
n:=12;
mm:=100;
for n in 10..1000 loop
insert into tab_test (Pk,TESTE) VALUES (cast(n as varchar(23)),cast(n as varchar(25)));
end loop;
commit;
end;

while 语句

declare
n integer;
mm integer;
begin
n:=12;
mm:=500000;
while n<mm loop
insert into V_k2(CONTACT_ADDRESS,EMPLOYEE_CODE) values('user'||cast(n as varchar(50))||'@fescoadecco.com',cast(n as varchar(20)));
n:=n+1;
end loop;
commit;
end;