--1、if
IF xx==1 WHEN
BEGIN
-- do something ...
END;
END IF;
--2、while
WHILE xx>4 LOOP
BEGIN
-- do something
END;
END LOOP;
--3、for in - cursor
CURSOR cur IS SELECT * FROM tableName ;
- -
...
IS
CURSOR cur IS SELECT * FROM xxtable;
BEGIN
FOR cur_result IN cur LOOP
BEGIN
v_sum := cur_result.colName1 + cur_result.colName2;
END;
END LOOP;
END;
--
CURSOR c_user(c_id NUMBER) IS SELECT NAME FROM xxtable WHERE xxx=c_id;
OPEN c_user(变量值)
LOOP
FETCH c_user INTO v_name;
EXIT FETCH c_user%NOTFOUND;
--dosomething ...
END LOOP;
--4、select ... into...
BEGIN
SELECT col1,col2 INTO xx1,xx2 FROM xxtable WHERE xxx ;
EXCEPTION
WHEN no_data_found THEN
xxx
END;
--5、