////////MUH WERK

Create table  PERSOANA2AB
(
cnp VARCHAR2(20) NOT NULL,
nume VARCHAR2(20) not null,
pren VARCHAR2(20) not null,
ddn DATE,
copii_intretinere copii_intretinereAB,
primary key (cnp)
);


create type copii_intretinere2AB as object
(
numec VARCHAR2(20),
ddnc VARCHAR2(20)
);

CREATE TABLE PERSOANA3AB (
CNP VARCHAR2(20) NOT NULL,
NUME VARCHAR2(20) NOT NULL,
PREN VARCHAR2(20) NOT NULL,
DDN VARCHAR2(20) NOT NULL,
COPII_INTRETINERE COPII_INTRETINERE2AB,
PRIMARY KEY (CNP)
);

INSERT INTO PERSOANA2AB VALUES (
'1996677666777', 'BOWIE', 'DAVID', '19/03/1955', COPII_INTRETINEREAB

('JIMMY')
);

INSERT INTO PERSOANA3AB VALUES (
'1996677666777', 'BOWIE', 'DAVID', '19/03/1955', COPII_INTRETINERE2AB

('CARSON', '20/12/2012')
);

DELETE FROM PERSOANA3AB WHERE CNP = '1996677666777';

SELECT * FROM PERSOANA3AB;
SELECT * FROM PERSOANA2AB;
SELECT P.COPII_INTRETINERE.PRENUMEC FROM PERSOANA2AB P;
SELECT P.COPII_INTRETINERE.NUMEC , P.COPII_INTRETINERE.DDNC FROM PERSOANA3AB P;