Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Unanswered: SQLLoader and MERGE command

    Hello,
    is there a way to use der MERGE command with the Sqlloader?

    If it's possible I think it should go like this:
    load data
    INFILE 'xxx.dat'
    "MERGE" INTO xxx
    "when matched then update set ..."
    "when not matched then insert ... values ..."
    APPEND
    FIELDS TERMINATED BY '~'
    (
    PROT_SQL_ID
    ...

    Thanks a lot for your help

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    I dont think you can but you could of course load it into a staging table and then use the sql MERGE command.

    Alan

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I agree with Alan ... as far as I know - you won't find any merge command in SQL*Loader.

    What you could do is to load your INFILE into a temporary table and then - through SQL check existence of matching records.

  4. #4
    Join Date
    Jan 2004
    Posts
    9
    of course there is allways a work arround, i was intrested in the direct way.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    run away from MERGE!

    run fast!
    - 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
  •