Thread: INSERT statement
11-15-09, 17:54 #1Registered User
- Join Date
- Nov 2009
Unanswered: INSERT statement
Can someone help me please?
I have created a simple database using oracle 10g Express edition.
I would like to insert data into two tables simultaneosly using the SQL query command line. For example, in my database there is an ActivityBooking table and an Equipment Booking table. So if a customer wants to book a canoe trip, he can also book canoes. I tried using the below format to try making these bookings but its not working.Gettin an error there is an invalid identifier or missing option.
SET AUTOCOMMIT OFF
INSERT INTO ACTIVITYBOOKING VALUES (BOOKING ID,ACTIVITY ID,DATE,NO.OF PERSONS);
INSERT INTO EQUIPMENTBOOKING VALUES (BOOKINGID,EQUIPMENTID,DATEBOOKED);
SET AUTOCOMMIT ON
11-15-09, 18:28 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
click on either
Your INSERT statements are not valid syntaxYou can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.