OraFAQ Forum: Server Utilities » load columns with spaces

Home » RDBMS Server » Server Utilities » load columns with spaces

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

load columns with spaces [message #169327]

Wed, 26 April 2006 05:07

papu
Messages: 27
Registered: March 2005
Location: Dhaka

Junior Member

hello all

can sql loader be used to load data from files with spaces?

for example

ACC_NO TR_DATE TRANS_AMT
----------------- ---------- ---------
20502050100000417 12-MAR-06 500000
20502050100002896 12-FEB-06 558640

i have a dat file which contains multiple records with the same formats. what will be the control file like.

regards

papu

Report message to a moderator