Bonjour, j'ai besoin d'un coup de main.
Pouvez-vous m'aide à resoudre ce probleme?
Voici ma vue :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 spool vue create or replace view RBaseTicket as select numS, dateRep, noPlace, noRang, statut from LesRepresentations_base natural join LesTickets ; Select * from RBaseTicket; create or replace view LesRepresentations as select RBaseTicket.numS as numS, RBaseTicket.dateRep as dateRep, P.numZ as numZ, RBaseTicket.statut as statut, RBaseTicket.noPlace as noPlace, RBaseTicket.noRang as noRang from ( LesPlaces P left outer join RBaseTicket ) on ((P.noPlace <> RBaseTicket.noPlace and P.noRang <> RBaseTicket.noRang) or (P.noPlace is null and P.noRang is null)) where (P.noPlace is null and P.noRang is null); Select * from LesRepresentations; spool off
voici le reponse de sqlplus :
from ( LesPlaces P left outer join RBaseTicket )
*
ERROR at line 5:
ORA-00905: missing keyword
Merci à toutes les personnes qui répondrons.
Partager