help: sqlldr control file
From: <ewong74_at_netscape.net>
Date: Tue, 30 Mar 1999 19:20:48 GMT
Message-ID: <7dr865$qs$1_at_nnrp1.dejanews.com>
Date: Tue, 30 Mar 1999 19:20:48 GMT
Message-ID: <7dr865$qs$1_at_nnrp1.dejanews.com>
Hi there, I have a outside source data file that contains 3 column seperated by tab. However, the data of the 3rd column itself has embedded tabs: A0001
B0001 C0001 a1 a2 a3
'A0001' is 1st column, 'B0001' is 2nd column, 'C0001 a1 a2 a3' is the 3rd column that has embedded tabs(number of tabs are different in different records). How can I define in the control file to load this using sqlldr?
Thanks in advance!
Ed
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 30 1999 - 21:20:48 CEST