摘要： 1. 定义变量declare n integer; //定义单个变量//定义多个变量DECLARE n integer;mm integer;2. 赋值n:=12;mm:=100;for 语句DECLAREn integer;mm integer;beginn:=12;mm:=100;for n in 10..1000 loopinsert into tab_test (Pk,TESTE) VALUES (cast(n as varchar(23)),cast(n as varchar(25)));end loop;commit;end;while 语句declaren integer;mm 阅读全文