[Oracle] pb à la création d'une vue
Bonjour, j'ai besoin d'un coup de main.
Pouvez-vous m'aide à resoudre ce probleme?
Voici ma vue :
Code:
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.