Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL question
I've created a type with this statement: Create Type animale as Object(
nome varchar2(25), tipo varchar2(25)
Then I created a table:
Create table Animali(
ID number, AN animale);
Then I insert a new record:
Insert into ANIMALI Values(1, Animale('bobby', 'dog'));
and it works.
But if i write:
SELECT ID, AN.nome from animali;
*
it tells me "invalid column name"
Can someone help me to find the error?
I use Oracle 8.1.6 and I find this example in the documentation.
Thank you in advance.
--Received on Thu May 17 2001 - 10:16:36 CDT
"Guai a coloro che il Signore troverà ad occhi asciutti"
"Blame on them the Lord will find with dry eyes"
(Gustavo Gutierrez)