General SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesGeneral SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old April 23rd, 2004, 10:11 AM
zishto zishto is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 8 zishto User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
error in table ...how to fix it ?

hi all

am working on a Hotel Reservation program ... and i have a proble with my tables...

i already finish the design and it seems ok for me ...but when i came to create the SQL Code for the tables it didnt work ... its giving me an error massage where is no error ... i seached and tryed my best to find a soulution but i couldnt ...

the error massage am getting is
ERROR at line 9:
ORA-00906: missing left parenthesis

all the parenthesis are exsist ...

could any one help me with this ...

here is the table that is not working ...

CREATE TABLE GUEST_ROOM
(
ROOM_NO NUMBER(3),
RESERVATION_NO NUMBER(5),
GUEST_NUMBER NUMBER(5) ,
ACTUAL_CHECKIN_DATE DATE NOT NULL,
ACTUAL_CHECKOUT_DATE DATE NOT NULL ,
CONSTRAINT ROOM_NO_FK FOREIGN KEY
REFERENCES ROOM_NO (ROOM_NO),
CONSTRAINT ROOM_RESERVATION_NO_FK FOREIGN KEY (RESERVATION_NO)
REFERENCES RESERVATION (RESERVATION_NO),
CONSTRAINT ROOM_GUEST_NUMBER_FK FOREIGN KEY (GUEST_NUMBER)
REFERENCES GUEST (GUEST_NUMBER)
);

i am also attaching all the tables ...

thanks and regards ...
Attached Files
File Type: doc hotel_Reservation.doc (32.5 KB, 180 views)

Reply With Quote
  #2  
Old April 30th, 2004, 12:54 PM
michlmann michlmann is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 56 michlmann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
You forgot to specify the key in the foreign key declaration:

CONSTRAINT ROOM_NO_FK FOREIGN KEY
REFERENCES ROOM_NO (ROOM_NO),

Should be

CONSTRAINT ROOM_NO_FK FOREIGN KEY (ROOM_NO)
REFERENCES ROOM_NO (ROOM_NO),

Reply With Quote
  #3  
Old May 2nd, 2004, 02:36 AM
zishto zishto is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 8 zishto User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
thaaaaaaaaaaaaaanx friend ... it works now ...

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesGeneral SQL Development > error in table ...how to fix it ?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway