Requete Mysql dans Oracle

Bonjour,

J'ai un petit probleme de SQL sur Oracle...
Je viens de migré une base de donné Mysql sur Oracle 10g release 2, la base de donné crée marche et il n'y as pas d'erreur apparente (mise a pars les probleme de nom reservé d'oracle: user, comment, type, etc).

Cependant j'ai un probleme d'SQL sur mon site web, ma requete est celle ci:

Code:

---

1 2

select t1.nodeid, t1.noleft, t1.noright, t1.title, t1.listid, 0 as reflevel ,(t1.noright-t1.noleft-1)/2 as nodescendant, t1.level_ as noancestor , count(e.documentid) as noelement from folder as t1, folder as t2 left join document e on e.nodeid = t2.nodeid where t1.nodeid='6' and t1.noright >= t2.noright and t1.noleft <= t2.noleft group by t1.nodeid, t1.noleft, t1.noright, t1.title, t1.listid, t1.level_ ;

---

Et l'erreur obtenu est celle ci:

Code:

---

1 2 3 4 5

select t1.nodeid, t1.noleft, t1.noright, t1.title, t1.listid, 0 as reflevel ,(t1.noright-t1.noleft-1)/2 as nodescendant, t1.level_ as noancestor , count(e.documentid) as noelement from folder as t1, folder as t2 left join document e on e.nodeid = t2.nodeid where t1.nodeid='6' and t1.noright >= t2.noright and t1.noleft <= t2.noleft group by t1.nodeid, t1.noleft, t1.noright, t1.title, t1.listid, t1.level_ *   ERROR at line 1: ORA-00933: SQL command not properly ended

---

Merci d'avance,
Mogweys.

Le moteur te le dis : enlève le "as" dans les alias de table.

Si possible ré-écris tes requêtes en utilisant uniquement la syntaxe normée :

Code:

---

1 2 3 4 5 6

from folder as t1 inner join folder as t2 on t1.noright >= t2.noright and t1.noleft <= t2.noleft left join document e on e.nodeid = t2.nodeid where t1.nodeid='6'

---

Merci bcp ...
j'avais zapper que le "as" ne se met pas pour les tables mais seulement pour les "row".

donc j'ai seulement remplace:

Code:

---

from folder as t1, from folder as t2

---

par:

Code:

---

from folder t1, from folder t2

---