SET HEADING  OFF
SET VERIFY   OFF
SET TERMOUT  OFF
SET FEEDBACK  OFF
SET TRIMSPOOL ON
SET UNDERLINE OFF
SET NEWPAGE  NONE
SET PAGESIZE  0
SET LINESIZE  2000
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK

DECLARE
 x NUMBER := 100;
BEGIN
FOR i IN 1..10 LOOP
  IF MOD(i,2) = 0 THEN     -- i is even
     INSERT INTO temp VALUES (i, x, 'i is even');
  ELSE
     INSERT INTO temp VALUES (i, x, 'i is odd');
  END IF;
  x := x + 100;
END LOOP;
COMMIT;
END; 

##</code><code>##

"sqlplus $Username $Password@SERVER test.sql "