procedureTest

--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、