DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Loader

  1. #1
    Join Date
    Aug 2003

    SQL Loader

    Can you use multiple WHEN conditions when loading data using SQL Loader?

    When INV_TYPE = 'IT'
    Load column A
    When INV_TYPE = 'IM'
    Load column B
    When INV_TYPE = 'OH'
    Load column C
    When INV_TYPE = 'II'
    Load column D

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    I believe so -- look at "SQL*Loader Case Study 5" in the Utilities Guide -- you could adapt the technique used there, i think.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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

Click Here to Expand Forum to Full Width