I've got a text file that looks something like below. I can use sqlldr
to get it in, and could potentially embed characters to use the
continueif next (1) = '#' feature, but I really want to preserve the
line lengths and paragraph indents. Long datatype will do that, but
haven't been able to figure it out using sqlldr. using 8.0.5 on NT.
also, embedding the "next" char(s) would be a chore.
Thanks
Cary
field1
field2
field3 start
:
field3 end
item no
author
description zzzzzzzzzzzzz
zzzzzzzzzzzzzz zzzzzzzzzzz
zzzzzzzzzzz
New paragraph of same descriptionzzzzzzzz
zzzzzzzzzz end of description
item no
author
desc..........
Sent via Deja.com http://www.deja.com/
Before you buy.