Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63

    Unanswered: How to specify decimal delimiter in sqlldr?

    Hello everybody,

    is it possible to specify a certain character as decimal delimiter in the ctl-file for the SQL Loader?

    Thanks for your help!

    Greetings
    Carsten

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296

    Re: How to specify decimal delimiter in sqlldr?

    Originally posted by CarstenK
    is it possible to specify a certain character as decimal delimiter in the ctl-file for the SQL Loader?
    PHP Code:
    fields terminated by '.' optionally exclosed by '"' 
    take out the optionally part if you want.
    put whatever you want as the delimiter inside signle quotes.
    this line would go right before your column specifications.
    - 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
  •