vytvor tabulku t1 s atributmi e,f 

CREATE TABLE T1(
    e INTEGER,
    f INTEGER
);

DELETE FROM T1;
INSERT INTO T1 VALUES(1, 3);
INSERT INTO T1 VALUES(2, 4);



vytvor dve premenne a,b
nacitaj z tabulky hodnoty e,f a v pripade ze e>1
vloz hodnoty opacne f,e 

DECLARE
    a NUMBER;
    b NUMBER;
BEGIN
    SELECT e,f INTO a,b FROM T1 WHERE e>1;
    INSERT INTO T1 VALUES(b,a);
END;
.

run;

vytvor dve premenne
pre hodnoty e vacsie ako 2
ak ak druha hodnota je rovna 1 napis opacne hodnoty
v opacnom pripade pridaj ku nim hodnotu 10


DECLARE
    a NUMBER;
    b NUMBER;
BEGIN
    SELECT e,f INTO a,b FROM T1 WHERE e>2;
    IF b=1 THEN
        INSERT INTO T1 VALUES(b,a);
    ELSE
        INSERT INTO T1 VALUES(b+10,a+10);
    END IF;
END;
.

run;


do tabulky t1 vlozte hodoty premennej x a jej y=x*x
pre x y intervalu 5 - 20
DECLARE
    x NUMBER := 5;

BEGIN
    LOOP
       INSERT INTO T1 VALUES(x,x*x);
        x := x+1;
        EXIT WHEN x>20;
    END LOOP;
 
END;
.

run;



vypis hodnot z ORACLE 





set serverout on size 10000;


DECLARE
    x NUMBER := 5;
    y number := 25;

BEGIN
    delete t1;
    LOOP
       y:=x*x;
       INSERT INTO T1 VALUES(x,y);

dbms_output.put_line(x ||'   '|| y);

        x := x+1;
        EXIT WHEN x>20;
    END LOOP;

dbms_output.put_line('pokusny riadok');

for i in 5..20 loop
    SELECT e,f INTO x,y FROM T1 where e=i;

    dbms_output.put_line(x ||'   '|| y);
 end loop;


select * from t1;

END;


.

run;