How to use Abstract datatype in Oracle

Create Type

create or replace type full_address_type
as object(
street varchar2(80),
city varchar2(80),
state char(2),
zip varchar2(10));

Create Table

create table customer(
full_name varchar2(50),
full_address full_address_type
);

Insert Data

insert into customer
values('Don Burleson',
full_address_type('123 1st st','Minoy','ND','74635'));

Select Row

Select full_name, C.full_address.state
from customer C;