[antikythera]

Hey I'm new to the site and I would first, before I ask for any help is to thank everyone in advance. You have my word that once I finish my schooling and become more proficient I will answer as many questions as possible to help the people who need it and to the people who need a break from question answering. I'll get to my question;

CREATE TABLE Booking
(hotelNo	CHAR(4) NOT NULL
,guestNo	CHAR(8)	NOT NULL
,dateFrom	DATE	NOT NULL
,dateTo	 DATE	NOT NULL
,roomNo	 CHAR(3) NOT NULL
,CONSTRAINT chk_roomNO
CHECK (roomNo BETWEEN 1 AND 100)
,CONSTRAINT chk_dateFrom
CHECK	(dateTo > SYSDATE())
,CONSTRAINT chk_dateTo
CHECK (dateTo < dateFrom)
);

why am I getting an error that im missing a right parenthesis (CHECK (dateTo > SYSDATE())).

[nK0de]

what's the DBMS you're using?
I checked your query with getdate() since I'm using SQL Server. no error was thrown..

[antikythera]

im using oracle data base 10 g express edition, i think its running sqlplus. I tried switching in Getdate(), insted of sysdat() and i get an error.

[nK0de]

I'm not familiar with Oracle server and PL/SQL. But I just googled and found out that both sysdate() and getdate() are valid in Oracle too.
What's the error you're getting this time? Is it the same error about missing a paran??

[antikythera]

im getting " a date or system variable wrongfully specified in check constraint.

[nK0de]

apparently u cannot use sysdate() in a check constraint it seems. see here and this answer too..

[JackOfAllTrades]

Moved to Oracle

[baavgai]

Sysdate isn't called with (), so that's one error. Unfortunately, you don't get to use sysdate in check constraints at all. You'll need a trigger for that kind of check.

Also, you chk_roomNO constraint doesn't make much sense, because your roomNo is char(3). Perhaps you wanted a number? There are a few places where it looks like you'd want number instead of char.