Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    38

    Unanswered: SQL Loader Question

    I have a question with respect to SQL Loader. I have memo fields which have hard carriage returns in them. In other words, some of my fields have ASCII (13) in them and it is very hard to import my data into ASCII because it does not allow one to change the new line delimiter which marks the end of the row.

    My question is whether or not SQL Loader in Oracle will do this. I know that I can use characters within SQL Loader for my characters which are to be delimitted. Can I use special characters for the end of record in SQL Loader?

    Thanks.

  2. #2
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    I have found no way in SQLLDR to do this.
    Either fixed length or delimited.

    I have had to go back to the source system and eliminate them there.


Posting Permissions

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