Advertisement
Guest User

Untitled

a guest
Oct 10th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.41 KB | None | 0 0
  1.  SET serveroutput ON
  2.  DECLARE
  3.  i NUMBER;
  4.  val NUMBER;
  5.  par VARCHAR2(50);
  6.  msg VARCHAR2(50);
  7.  BEGIN
  8.  FOR i IN 1..100 LOOP
  9.    IF (MOD(i,2) = 0) THEN
  10.     val:=1;
  11.    ELSIF (i=1) THEN
  12.     val := 0;
  13.    ELSE
  14.     val := 0;
  15.    END IF;
  16.    IF (val=1) THEN
  17.     par:='par';
  18.    ELSE
  19.     par:='ímpar';
  20.    END IF;
  21.    INSERT INTO  temp (col1,col2,message) VALUES (i,i*100,'Col1 é '||par);
  22.    END LOOP;
  23.  
  24.  END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement