SQL question
From: Michele de Concilio <mdeconcilio_at_sge.it>
Date: Thu, 17 May 2001 17:16:36 +0200
Message-ID: <3B03EB54.E8015132_at_sge.it>
);
and it works.
and it works too.
Date: Thu, 17 May 2001 17:16:36 +0200
Message-ID: <3B03EB54.E8015132_at_sge.it>
I've created a type with this statement: Create Type animale as Object(
nome varchar2(25), tipo varchar2(25)
);
and it works.
Then I created a table:
Create table Animali(
ID number, AN animale);
and it works too.
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 - 17:16:36 CEST
"Guai a coloro che il Signore troverà ad occhi asciutti"
"Blame on them the Lord will find with dry eyes"
(Gustavo Gutierrez)