ERROR at line 1:ORA-00928: missing SELECT keyword
I am new to oracle I am working with the Oracle Press book the complete reference and the appendix has samples I am trying to create these tables for example CUSTOMER:
rem Requires that the ADDRESS_TY and PERSON_TY types already
rem exist.
create table CUSTOMER (
Customer_ID NUMBER,
Person PERSON_TY
);
insert into CUSTOMER
(1,
PERSON_TY('NEIL MULLANE',
ADDRESS_TY('57 MT PLEASANT ST',
'FINN', 'NH', 11111)));
insert into CUSTOMER
(2,
PERSON_TY('SEYMOUR HESTER',
ADDRESS_TY('1 STEPAHEAD RD',
'BRIANT', 'NH', 11111)));
when I paste it into oracle it comes back with ERROR at line 1:ORA-00928: missing SELECT keyword since I am taking the straight from the book I don't know what is going wrong Please forgive me if this question is too easy I am new to this any help would be greatly appreciated.
By the way the ADDRESS_TY and PERSON_TY types already
exist.
if I am posting this in the wrong forum forgive me.
thanks in advance
Joel