CREATE OR REPLACE TYPE O_BAGAZAS_LIETAS AS OBJECT(
    NOSAUKUMS VARCHAR(50),
    SVARS FLOAT
);
 
CREATE OR REPLACE TYPE O_BAGAZS AS OBJECT(
    BAGAZAS_LIETAS REF O_BAGAZAS_LIETAS
);
 
CREATE OR REPLACE TYPE O_PASAZIERI AS OBJECT(
    UZVARDS VARCHAR(30),
    VARDS VARCHAR(20),
    BAGAZS REF O_BAGAZS
);
 
CREATE OR REPLACE TYPE O_STUARTES AS OBJECT(
    UZVARDS VARCHAR(30),
    VARDS VARCHAR(20)
);
 
CREATE OR REPLACE TYPE O_PILOTI AS OBJECT(
    UZVARDS VARCHAR(30),
    VARDS VARCHAR(20)
);
 
CREATE OR REPLACE TYPE O_BRIGADES AS OBJECT(
    NUMURS NUMBER,
    APZIMEJUMS VARCHAR(100),
    PILOTI REF O_PILOTI,
    STUARTI REF O_STUARTES
);
 
CREATE OR REPLACE TYPE O_LIDMASINA AS OBJECT(
    TIPS VARCHAR(50),
    NUMURS NUMBER,
    BRIGADES REF O_BRIGADES
);
 
CREATE OR REPLACE TYPE O_REISI AS OBJECT(
    NUMURS NUMBER,
    NOSAUKUMS VARCHAR(30),
    PASAZIERI REF O_PASAZIERI,
    LIDMASINAS REF O_LIDMASINA
);
 
CREATE OR REPLACE TYPE O_LIDOSTAS AS OBJECT(
    NUMURS NUMBER,
    NOSAUKUMS VARCHAR(30),
    TELEFONI NUMBER,
    REISI REF O_REISI
);
 
CREATE TABLE LIDOSTA_TBL(
    LIDOSTA O_LIDOSTAS NOT NULL
);

INSERT INTO LIDOSTA_TBL VALUES (LIDOSTA(55, 'TEST', 258925, 
REISI(258952, 'AFJKAF', 
PASAZIERI('TEST', 'TEST', 
BAGAZS(BAGAZAS_LIETAS('JDASK', 9155.25)), 
LIDMASINAS('BOING', 51205, 
BRIGADES(81295, '125ASJKFJ981JF8A8', 
PILOTI('TEST', 'TEST'), 
STUARTI('TEST', 'TEST')
)))));

INSERT INTO LIDOSTA_TBL VALUES (LIDOSTA(55, 'TEST', 258925, 
REISI(258952, 'AFJKAF', 
PASAZIERI('TEST', 'TEST', 
BAGAZS(BAGAZAS_LIETAS('JDASK', 9155.25)), 
LIDMASINAS('BOING', 51205, 
BRIGADES(81295, '125ASJKFJ981JF8A8', 
PILOTI('TEST', 'TEST'), 
STUARTI('TEST', 'TEST')
))))));

INSERT INTO lidosta_tbl VALUES ( o_lidostas(55, 'TEST', 258925, o_reisi(258952, 'AFJKAF', o_pasazieri('TEST', 'TEST', o_bagazs(o_bagazas_lietas
('JDASK', 9155.25))), o_lidmasina('BOING', 51205, o_brigades(81295, '125ASJKFJ981JF8A8', o_piloti('TEST', 'TEST'), o_stuartes('TEST', 'TEST'
))))) );

REISI REF O_REISI