SET serveroutput ON;

 CREATE TABLE Pom7_1
  AS SELECT *
  FROM Dealerzy;
  DELETE FROM pom7_1;

  --SELECT * FROM MARKI;

  DECLARE
  CURSOR C_PS7_2(nazw_m Marki.Nazwa%TYPE)
  IS
  SELECT *
  FROM Dealerzy
  WHERE IdDealera IN (SELECT IdDealera
                      FROM Samochody
                      WHERE IdModelu IN (SELECT IdModelu
                      FROM Modele
                      WHERE idmarki IN (SELECT idmarki
                                        FROM marki
                                        WHERE nazwa = nazw_m)));
v_dealer dealerzy%ROWTYPE;
BEGIN
  OPEN c_ps7_2('Mercedes');
  LOOP
    FETCH c_ps7_2 INTO v_dealer;
    INSERT INTO pom7_1 VALUES v_dealer;

  EXIT WHEN (c_ps7_2%notfound);

  END LOOP;
  CLOSE c_ps7_2;
END;