ORA-00933: SQL command not properly ended
From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Fri, 04 Jan 2013 17:07:47 +0100
Message-ID: <50E6FE53.3040801_at_sferacarta.com>
Hi all,
Date: Fri, 04 Jan 2013 17:07:47 +0100
Message-ID: <50E6FE53.3040801_at_sferacarta.com>
Hi all,
I have a query that succeed in postgres but it fails in oracle and I don't know why?
select v.articolo,fs.descrizione as
fontes,s.articolo,s.importo_min,s.importo_max from norma as s join norma
as v on s.id = v.id_norma_sanzionatoria join fonte as fv on
v.id_fonte=fv.id join fonte as fs on s.id_fonte=fs.id;
articolo | fontes | articolo | importo_min | importo_max
------------------+--------------+---------------+-------------+------------- articolo violata | DLG 431/2008 | sanzionatoria | 700.00 | 800.00(1 row)
select v.articolo,fs.descrizione as
fontes,s.articolo,s.importo_min,s.importo_max from norma as s join norma
as v on s.id = v.id_norma_sanzionatoria join fonte as fv on
v.id_fonte=fv.id join fonte as fs on s.id_fonte=fs.id;
cx_Oracle.DatabaseError: ORA-00933: SQL command not properly ended
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 04 2013 - 17:07:47 CET