Hi there I need to create a Table that will allow me to input

using

insert into booking values(bookings.NEXTVAL,'Chung Gon','(08) 8983 1840','S',
'27-MAY-04',5,'Baby bassinet');

I've created the table below

Create Table booking
(Name CHAR(20),
Phone VARCHAR(20),
RoomType VARCHAR(2),
BookingDate Date,
NightsStaying VARCHAR(20),
REQUIREMENTS CHAR(20));

And when I use the Insert command I get to many values any suggestions on how to fix this? (Fairly new to SQL and Oracle)

Thx.

what's the bookings.NEXTVAL for??? You shouldn't need that.

Maybe you need to create the table like this:

Whatever it is, you need to create a column for it. There is no such function in SQL Server though.

NEXTVAL is an Oracle thing, which is the database engine that Omega is using. It roughly corresponds to an IDENTITY function (not column) in MS-SQL.

The problem appears to be that there are six columns listed in the table, but there are seven values in the SELECT list. Oracle has a tough time figuring out what omega really wants to do!

-PatP

bookings.NEXTVAL comes from a sequence. So, your code should be something like:
Your INSERT statement should now work properly.

Try......


insert into booking values('Chung Gon','(08) 8983 1840','S',
'27-MAY-04',5,'Baby bassinet');

as your create table descrptions has 6 cols only.