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.