Re: (DatabaseError) ORA-00905: missing keyword

From: <rajugaru.vij_at_gmail.com>
Date: Mon, 18 Mar 2013 10:20:36 +0000
Message-ID: 2062257375-1363602032-cardhu_decombobulator_blackberry.rim.net-1176552647-_at_b28.c12.bise7.blackberry>

Sorry, I didn't get it.. You mean AS keyword is not require to alias a table? Sent on my BlackBerry®

-----Original Message-----
From: Jose Soares <jose.soares_at_sferacarta.com> Sender: oracle-l-bounce_at_freelists.org Date: Mon, 18 Mar 2013 11:15:48
To: <oracle-l_at_freelists.org>
Reply-To: jose.soares_at_sferacarta.com
Subject: Re: (DatabaseError) ORA-00905: missing keyword

sorry I was too hasty, I found the error :-[ Oracle don't want the keyword AS to rename a table name. thanks anyway
j.

On 03/18/2013 11:10 AM, Jose Soares wrote:
> Hi all,
>
> I can't execute this query in oracle:
>
> select * from ( ( ( ( ( ( ( ( ( ( (scadenziario join sopralluogo on
> scadenziario.id_sopralluogo = sopralluogo.id)join unita_aziendale on
> sopralluogo.id_unita_aziendale = unita_aziendale.id) join
> sopralluogo_operatore on sopralluogo.id =
> sopralluogo_operatore.id_sopralluogo) join operatore on
> sopralluogo_operatore.id_operatore = operatore.id) join anagrafica as
> anagrafica_operatore on operatore.id_anagrafica =
> anagrafica_operatore.id) join operatore as operatore_programmato on
> scadenziario.id_veterinario_programmato = operatore_programmato.id)
> join anagrafica as an_op_programmato on
> operatore_programmato.id_anagrafica = an_op_programmato.id )join
> azienda on unita_aziendale.id_azienda = azienda.id) join distretto on
> distretto.id = azienda.id_distretto) join anagrafica as
> anagrafica_distretto on distretto.id_anagrafica =
> anagrafica_distretto.id) join piano on scadenziario.id_piano =
> piano.id) join anagrafica on unita_aziendale.id_anagrafica =
> anagrafica.id where piano.tipo ='U' and
> sopralluogo_operatore.principale = '1'"
>
> (DatabaseError) ORA-00905: missing keyword
>
>
> it works in postgres.
>
>
> Could someone help me?
> Thanks for any help
> j
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 18 2013 - 11:20:36 CET