Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL question

SQL question

From: Michele de Concilio <mdeconcilio_at_sge.it>
Date: Thu, 17 May 2001 17:16:36 +0200
Message-ID: <3B03EB54.E8015132@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.

-- 

"Guai a coloro che il Signore troverà ad occhi asciutti"
"Blame on them the Lord will find with dry eyes"
(Gustavo Gutierrez)
Received on Thu May 17 2001 - 10:16:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US