Re: SQL question

John Edward Scott wrote:
>
>
> You need to alias the table, try using
>
> select r.id, r.an.nome from animali r;
>
> John.
>
> "Michele de Concilio" <mdeconcilio_at_sge.it> wrote in message
> news: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.
> > --
> > "Guai a coloro che il Signore trover ad occhi asciutti"
> > "Blame on them the Lord will find with dry eyes"
> > (Gustavo Gutierrez)
>
> Well u created your table u shouldn't leave a space between the "AN
animale", try this.... AN_ANIMAL... Oh if u made up your mind using lower_case than have all the columns in lower_case... Don't interchange them, u could but when u search the table u gotta type in the same letter case as u did when u created the table.

   Create table Animali(
   ID number,
   AN_ANIAMLE VARCHAR2(40));   Now search the table for the information!!   

  SELECT ID, AN_ANIMALE
  FROM ANIMALI;

--
Posted via CNET Help.com
http://www.help.com/