forloop.sql

来自「Oracle 9i PL/SQL程序设计的随书源码」· SQL 代码 · 共 12 行

REM forloop.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This is an example of a FOR loop.

BEGIN
  FOR v_Counter IN 1..50 LOOP
    INSERT INTO temp_table
      VALUES (v_Counter, 'Loop Index');
  END LOOP;
END;
/