Probleme projet sql
stephenking
-
stephenking -
stephenking -
Bonjour, j'ai besoin d'un coup de main.
Pouvez-vous m'aide à resoudre ce probleme?
Voici ma vue :
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.
Pouvez-vous m'aide à resoudre ce probleme?
Voici ma vue :
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.
A voir également:
- Probleme projet sql
- Filigrane projet - Guide
- Gant projet - Télécharger - Gestion de projets
- Logiciel sql - Télécharger - Bases de données
- Requete sql pix - Forum PHP
- Jointure sql ✓ - Forum MySQL