INSERT INTO meny (kod,nazev) SELECT DISTINCT kod_meny, nazev_meny FROM imp_temporary;
SELECT * FROM meny;

INSERT INTO ZEME (KOD,NAZEV,KOD_MENY) SELECT DISTINCT kod_zeme, nazev_zeme, kod_meny FROM imp_TEMPORARY;
SELECT * FROM zeme_M;

INSERT INTO KURZY (id, platnost_od, kurz, KOD_MENY_Z,KOD_MENY_DO)
SELECT rownum, platnost, kurz, kod_meny, mena_do FROM (
SELECT DISTINCT
to_date(platnost_kurzu_od,'dd.mm.yy hh24:mi:ss') platnost,
to_number (kurz) kurz,
kod_meny,
mena_do
FROM imp_tmp);

SELECT * FROM kurzy;

INSERT INTO Pobocky(id_pobocky ,nazev,adresa ,mesto,telefon,kod_zeme)
SELECT DISTINCT
to_number(id_pobocky) id_pobocky ,nazev,adresa ,mesto,telefon,zeme
FROM imp_TEMPORARY2;

CREATE SEQUENCE seq_imp_tmp;

INSERT INTO Pracovnici(id,jmeno,prijmeni,plat,id_pobocky)
SELECT seq_imp_tmp.NEXTVAL,jmeno,prijmeni,plat,id_pobocky FROM (
SELECT DISTINCT  jmeno,prijmeni,plat, to_number(id_pobocky)id_pobocky
FROM imp_TEMPORARY2);

DROP SEQUENCE seq_imp_tmp;

INSERT INTO Zbozi(id_zbozi ,kategorie, nazev, typ , popis,cena,kod_meny )
SELECT DISTINCT  to_number(id_zbozi) id_zbozi ,kategorie, název, typ,
popis,to_number(cena)cena,mena
FROM imp_TEMPORARY3;

INSERT INTO Prodeje(datum_prodeje,datum_kurzu,mnozstvi,cena_za_ks,id_pobocky ,kod_meny ,id_zbozi )
SELECT DISTINCT  to_date(datum_prodeje,'dd.mm.yy hh24:mi:ss')
datum_prodeje, to_date(datum_kurzu,'dd.mm.yy hh24:mi:ss')datum_kurzu,
kus,to_number(cena)cena,to_number(id_prodejny)id_prodejny, mena ,
to_number(id_zbozi) id_zbozi FROM imp_TEMPORARY4;