Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Unanswered: Multi Table Insert (8i vs 9i)

    Hi
    I am trying to use a multi table insert in 8i.
    I am using the following format.
    INSERT ALL
    WHEN email like '%XYZ.com' THEN
    INTO T1 values (email)
    WHEN email like '%ABC.com' THEN
    INTO T2 values (email)
    SELECT email from TABLE1

    The SQL complains
    14:35:21 DBNAME SQL> /
    insert ALL
    *
    ERROR at line 1:
    ORA-00925: missing INTO keyword


    I am not sure as to when the multitable inserts (unconditional ALL, conditional ALL) came into the picture. I suspect it started all in 9i, but I wanted to confirm the same, and also if it is my syntax of the inserts.

    I would appreciate your response.

    Regards
    Aruneesh

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    9i feature. If in doubt on technet they have oracle sql manuals for both 8i and 9i.

    Alan

  3. #3
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Alan

    Hi Alan
    I must say that 9i is coming out with some excellent features as compared to 8i, like insert all, timestamp ....
    I wanted to know about insert all as yesterday I took the 1Z0-007 exam. It wasnt that bad.
    Now I am gearing to take the 1Z0-031 exam sometime soon.
    Regards
    Aruneesh

Posting Permissions

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