create or replace type IndirizzoTY as object
(via varchar(30),
comune varchar(20),
provincia char(2));

create or replace type PersonaTY as object
(cognome varchar(20),
nome varchar(15),
indirizzo indirizzoTY);

create table Persona of PersonaTY;

insert into persona values('Insegno','Pino',IndirizzoTY('Via
Dante','Roma','Rm'));
-----------------------------------------------------------------------------------------

select indirizzo.via from persona;

ORA-00904: "INDIRIZZO"."VIA": identificativo non valido

.....
Which is the correct sql command?

Shearer schreef:
Try this:

select p.indirizzo.via from persona p;

Somewhere I read (can't rememeber where) that user defined types should
be accessed via the alias of the table.
I tested this on Oracle XE and it works!

Shakespeare

Shearer schreef:
Try this:

select p.indirizzo.via from persona p;

Somewhere I read (can't rememeber where) that user defined types should
be accessed via the alias of the table.
I tested this on Oracle XE and it works!

Shakespeare

Shearer schreef:
Try this:

select p.indirizzo.via from persona p;

Somewhere I read (can't rememeber where) that user defined types should
be accessed via the alias of the table.
I tested this on Oracle XE and it works!

Shakespeare

Shearer schreef:
Try this:

select p.indirizzo.via from persona p;

Somewhere I read (can't rememeber where) that user defined types should
be accessed via the alias of the table.
I tested this on Oracle XE and it works!

Shakespeare