Results 1 to 4 of 4

Thread: Sqlldr Query

  1. #1
    Join Date
    Feb 2005
    Posts
    29

    Unanswered: Sqlldr Query

    Hi,

    Just a basic query. In the sqlldr, we had used this command - OPTIONALLY ENCLOSED BY '"'. We expect all the string characters in enclosed in double quoted. However, when the string itself has ", that particular record fails to load. Is this expected?

    One way is to request the owner of the data to replace the " with blank spaces or null values.
    I was hoping if is there any way we can handle this at our end itself?

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Think about what you're saying:

    "When I reach a quote then that's the end of the field, unless I reach a quote in which case ignore it as it's not the end of the field"

    What was you expecting Oracle to do?

    I would get back to the data owner & ask them to change the delimiter.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If a double quote is in the string, you can do two things. change the delimiter or add another double quote. For example

    "my name is ""bill""." would be parsed as

    my name is "bill".
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    do you want the double quote loaded into the DB or do you want sqlloader to
    remove the double quotes regardless.

    ie: load ""my string"" into the db as my string <-- no quotes at all

    is that how the problem areas look? with double-double quotes?
    or, are ther double quotes WITHIN the text ie:
    my "string" is quoted
    - 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
  •