Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    24

    Unanswered: SQL Loader - Using Select from clause

    Hi!

    I need the ability to use an select from clause in my sqlloader ctl file (including a join).

    i get a value from my *.csv file which I have to join from another table, and insert the result.
    How is this with the sql loader possible?
    I have to store the value from the *.csv file and put it into the join syntax. the result has to be inserted using the sql loader

    Thanks,
    Klaus

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    Create a function to return 'joined' value.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you are on Oracle 9i or above, use an external table instead of sql loader and simply join the external table column to your other table and do the insert into the staging table.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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