question about external files

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Jan 2005 13:49:45 -0500

I'm trying to load a file that has a field that can be > 4000 characters.
external files don't let you use a clob so I'm using a varchar2(4000).
problem is I don't want any rejected records but it's ok to only grab the
first 4000 characters. so how do I do this in external files, sqlloader I
could substr the column.


Other related posts: