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

Thread: Carriage Return in SQLLoader

  1. #1
    Join Date
    Feb 2002
    Posts
    5

    Question

    I want to insert data in a table through SqlLoader and one field(Varchar2) contains data with carriage return.How can I insert the data with carriage return ?
    I tried the options from Metalink but they are not working.
    Can anybody please guide me ?
    Thanks ,
    Vasant

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    Can you strip carriage return off the field? It may be coded with ASCII control-M or one of these methods:

    Dec Oct Hex Binary Description

    013 015 0D 00001101 ^M ^m CR cr carriage-return c-M c-m \r

    Use position statment to exclude carriage return.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  3. #3
    Join Date
    Apr 2001
    Posts
    219
    I have a file at work that may help, but I will not be in work until Tuesday.

    ______________________
    Applications come and go,
    but the data remains!

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