Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE OR REPLACE TYPE  "COLECTION_OF_CONTACTS" IS 
    TABLE OF VARCHAR2(30); 
/
CREATE OR REPLACE TYPE  "ADRESA" AS OBJECT ( 
    mesto         VARCHAR2(36), 
    ulice         VARCHAR2(36), 
    popisne_cislo VARCHAR2(36), 
    psc           VARCHAR2(36) 
) NOT FINAL; 
/
CREATE TABLE  "UKLIZECKA" 
   (    "ID" NUMBER NOT NULL ENABLE, 
    "JMENO" VARCHAR2(32) NOT NULL ENABLE, 
    "PRIJMENI" VARCHAR2(32) NOT NULL ENABLE, 
    "DATUM_NAROZENI" DATE NOT NULL ENABLE, 
    "KONTAKT_UKLIZECKA"  "COLECTION_OF_CONTACTS" , 
    "ADRESA"  "ADRESA" , 
    "OBLAST_UKLIDU_ID" VARCHAR2(21) NOT NULL ENABLE, 
     CHECK ( adresa.mesto IS NOT NULL ) ENABLE, 
     CHECK ( adresa.ulice IS NOT NULL ) ENABLE, 
     CHECK ( adresa.popisne_cislo IS NOT NULL ) ENABLE, 
     CHECK ( adresa.psc IS NOT NULL ) ENABLE, 
     CONSTRAINT "UKLIZECKA_PK" PRIMARY KEY ("ID") ENABLE
   ) 
 NESTED TABLE "KONTAKT_UKLIZECKA" STORE AS "KONTAKT_UKLIZECKA"
 RETURN AS VALUE
/
ALTER TABLE  "UKLIZECKA" ADD CONSTRAINT "UKLIZECKA_OBLAST_UKLIDU_FK" FOREIGN KEY ("OBLAST_UKLIDU_ID")
      REFERENCES  "OBLAST_UKLIDU" ("ID") ENABLE
/
ORA-00942: table or view does not exist

ALTER TABLE  "UKLIZECKA" ADD CONSTRAINT "UKLIZECKA_ZAMESTNANEC_FK" FOREIGN KEY ("ID")
      REFERENCES  "ZAMESTNANEC" ("ID") ENABLE
/
ORA-00942: table or view does not exist

CREATE UNIQUE INDEX  "UKLIZECKA__IDX" ON  "UKLIZECKA" ("OBLAST_UKLIDU_ID")
/
insert into uklizecka (
  id, jmeno, prijmeni, datum_narozeni, kontakt_uklizecka, adresa, oblast_uklidu_id
)values(
  312,'john','doe',date '2000-10-10',COLECTION_OF_CONTACTS('123123'),ADRESA('city','street','123','123'),'first_floor'
)
1 rows affected