SQL*Loader

From: Alex A. <albu_at_mailcity.com>
Date: Sat, 02 Oct 1999 22:24:48 GMT
Message-ID: <7t60nb$b2i$1@nnrp1.deja.com>

Hi everyboby,

I am trying to import data into a table using SQL*Loader. My table has two fields:
test(id number(6), body varchar(1000))

In the input file, the fields are separated by commas and the character field is enclosed in double quotes. But the text column contains newline characters. The input file looks something like: 1,"This is a text that
spans more than
one line"
2,"This is a short text"
3,"Again a long
text"

How do I write the control file for the import?

TIA
Alex

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 02 1999 - 17:24:48 CDT