-----------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------------------------------------------
create type address_ty as object
(
        city              varchar2(25),
        street            Varchar2(25)
);
/
-----------------------------------------------------------------------
create type birth_ty as object
(
        DOB             Date,
        POB             Varchar2(25)
);
/
-----------------------------------------------------------------------
create type name_ty as object
(
	fname	varchar2(25),
	mname	varchar2(25),
	lname	varchar2(25)
);
/
-----------------------------------------------------------------------
CREATE TYPE PHONE_TY AS OBJECT  
( 
        MOBILE  VARCHAR2(13),
        HOME    VARCHAR2(13)  
);
/
-----------------------------------------------------------------------