I have the following Type Address and PhoneNumber:
CREATE TYPE Adress AS Object (Street varchar2(50), PostalC number, Ville varchar2(50));
CREATE TYPE PhoneNumber AS Object (Ind varchar2(3), PhNumber varchar2(20));
If a person can have many children and a child can have only 2 persons as parents what are the modification I need to have in my Person type below :
CREATE TYPE Person;
CREATE TYPE Person AS Object (
FirstName varchar2(50), LastName varchar2(50), Adr Address , Father REF Person, Mother REF Person);
Is to correct to have a self reference (Father and Mother) to the same type?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…