Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    4

    Unanswered: Merging statement

    Hi everyone,

    there is new featuer in oracle 10g which is " Merging Statement ".
    Can you please explain to me this featuer?

    IT Man
    Rgds

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    http://download-west.oracle.com/docs...13_elems30.htm

    it was already available with 9i and is something like upsert

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    to be honest I found MERGE to either be buggy, or not very efficient (on 9i).
    Seemed to me I could just as easily write an insert with a dblink.
    I tried to follow the docs as close as I could and could not seem to get it to work.
    Meanwhile I could have written an insert statement in 2 minutes!

    Just my opinion from the experience I had.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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