--1
SELECT *
FROM KSIAZKA_TEMP;
INSERT INTO KSIAZKA_TEMP SELECT *
                         FROM T_KSIAZKA;

DECLARE
  cr1 ksiazka_temp%ROWTYPE;
  cr2 ksiazka_temp%ROWTYPE;

  CURSOR c1 IS SELECT tytul
               FROM KSIAZKA_TEMP k, T_Z_KSIAZKA z
               WHERE k.ISBN != z.ISBN;

  CURSOR c2 IS SELECT tytul
               FROM KSIAZKA_TEMP k, T_Z_KSIAZKA z
               WHERE k.ISBN != z.ISBN AND (SELECT COUNT(z.ISBN)
                                           FROM z) > 2;
BEGIN
  FOR cr1 IN c1 LOOP
    DELETE FROM KSIAZKA_TEMP
    WHERE TYTUL = cr1.TYTUL;
  END LOOP;

  FOR cr2 IN c2 LOOP
    UPDATE KSIAZKA_TEMP
    SET cena = 1.1 * cr2
    WHERE CURRENT OF cena;
  END LOOP;

END;

SELECT *
FROM KSIAZKA_TEMP;