Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered: INSERT statement

    Hi there

    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);
    COMMIT;
    SET AUTOCOMMIT ON

    RUN

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    INSERT

    click on either

    Syntax

    or

    Examples

    Your INSERT statements are not valid syntax
    You 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •