Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Issue with SQL Loader

    Hi,
    I have a problem with sql loader control file.
    i have a csv file where i have search for "|"(pipe) for all the values and if pipe is found in the string then it has to be loaded in to a table else it has to go in .bad file..
    any suggestions pls let me know ASAP

    Regards
    GP

  2. #2
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171

    Re: Issue with SQL Loader

    You can use a WHEN clause in the control file to load data on condition. The rejected ones will go in a discard file.

    Originally posted by gpai
    Hi,
    I have a problem with sql loader control file.
    i have a csv file where i have search for "|"(pipe) for all the values and if pipe is found in the string then it has to be loaded in to a table else it has to go in .bad file..
    any suggestions pls let me know ASAP

    Regards
    GP
    Oracle can do wonders !

  3. #3
    Join Date
    Feb 2004
    Posts
    2

    Unhappy

    hi cmasharma
    i appreciate your reply..
    but the problem if i use "when" i cannot use INSTR for checking "|" is found or not in a particular string. guess u need to put the just the column name in the when clause
    so using WHEN clause is out of question..
    any workarounds that will be helpful...

    regards
    GP

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    Try an alternative:

    http://asktom.oracle.com/pls/ask/f?p...:1615330671789

    if it helps ...
    Oracle can do wonders !

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    my suggestion is to load everything into oracle and write a proc to do what you want.

    sqlloader is time-consuming at best when attempting to configure these things. If you just load the data into ta temp table you can write a proc very quickly.
    - 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
  •