Oracle 控制語句

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 integer;beginn:=12;mm:=500000;while n<mm loopinsert 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;