| Problem with Creating a View [message #54736] |
Mon, 02 December 2002 10:34  |
MikeBarbino
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
I ahve entered this but am not sure why it is not working. Please Help.
1 create view RES AS
2 Select Flight.FltNo, SCHEDFLT.Fltdate, SCHEDFLT.PlaneID, AptName, DepApt,
3 Deptime, PilotName, PassName
4 From AIRPORT, FLIGHT, PASSENGER, PILOT, RESERVATION, SCHEDFLT
5 Where AIRPORT.Aptcode = FLIGHT.DepApt and
6 Reservation.PassID = PASSENGER.PassID and
7 reservation.fltno = schedflt.fltno and reservation.fltdate =
8 schedflt.fltdate
9 and Pilot.PilotID = SCHEDFLT.PilotID and
10 SCHEDFLT.CoPilotID = PILOT.PilotID
11 and SCHEDFLT.FltNo = Flight.FltNo and
12* RESERVATION.FltDate Between '12/03/2002' and '12/09/2002'
SQL> 12
12* RESERVATION.FltDate Between '12/03/2002' and '12/09/2002'
SQL> i
13 ORDER BY FLIGHT.FltNo ASC;
ORDER BY FLIGHT.FltNo ASC
*
ERROR at line 13:
ORA-00933: SQL command not properly ended
|
|
|
|
| Re: Problem with Creating a View [message #54737 is a reply to message #54736] |
Mon, 02 December 2002 10:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
create view RES AS
select Flight.FltNo, SCHEDFLT.Fltdate, SCHEDFLT.PlaneID, AptName, DepApt,
Deptime, PilotName, PassName
From AIRPORT, FLIGHT, PASSENGER, PILOT, RESERVATION, SCHEDFLT
Where AIRPORT.Aptcode = FLIGHT.DepApt and
Reservation.PassID = PASSENGER.PassID and
reservation.fltno = schedflt.fltno and
reservation.fltdate = schedflt.fltdate and
Pilot.PilotID = SCHEDFLT.PilotID and
SCHEDFLT.CoPilotID = PILOT.PilotID and
SCHEDFLT.FltNo = Flight.FltNo and
RESERVATION.FltDate Between '12/03/2002' and '12/09/2002' and -- [b]u missed the operator here and / or???[/b]
RESERVATION.FltDate Between '12/03/2002' and '12/09/2002'
ORDER BY FLIGHT.FltNo ASC
|
|
|
|
|
|
| Re: Problem with Creating a View [message #54739 is a reply to message #54736] |
Mon, 02 December 2002 11:00 |
|
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
something is messing up with your editor / editing.
(dont use 'i' mode etc)
open the same sql in a notepad and dont add a semicolon ';' at end.
copy and compile the sql again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
