Re: Carriage Returns and SQL*Loader
From: John Jones <john_at_iluvatar.tip.duke.edu>
Date: 1995/06/06
Message-ID: <Pine.NXT.3.90.950606081210.1014A-100000_at_iluvatar>#1/1
Date: 1995/06/06
Message-ID: <Pine.NXT.3.90.950606081210.1014A-100000_at_iluvatar>#1/1
We had this same problem. We were converting from FoxPro memo fields to oracle long fields. What we did was in FoxPro we put a special character where the carriage return was, then we loaded into Oracle using sqlloader and then once in Oracle we used the replace function in Sql*Plus to replace the special character with a carriage return.
John Jones | my views are my own......... Oracle Consultant | no matter what company they are john_at_iluvatar.tip.duke.edu | coming from.Received on Tue Jun 06 1995 - 00:00:00 CEST
--------------------------------------------------------------------