SQL> create or replace type person_name_type as obje
  2  ( first_name varchar2(10),
  3  middle_name varchar2(10),
  4  last_name varchar2(10) );
  5  /

Type created.

SQL> create table name
  2  ( name person_name_type not null
  3  );

Table created.

SQL> select  *
  2    from  name
  3  /

NAME(FIRST_NAME, MIDDLE_NAME, LAST_NAME)
----------------------------------------------------
PERSON_NAME_TYPE('Joe', 'M', 'Schmoe')

SQL>

SQL> INSERT INTO name VALUES
  2      (PERSON_NAME_TYPE('Joe', 'M', 'Schmoe')
  3      );

1 row created.