Last post Apr 11, 2010 06:09 PM by mattatuni2
Apr 11, 2010 12:42 PM|mattatuni2|LINK
Hi Im importing a simple data set using sql loader, below is the controll file im using...
The field named 'CustName' imports all the records but surround them in the oracle table with single quotes ... eg 'Dave' .. not Dave.. how can i alter the control file to remove these sinngle quotes when the data is imported...
The field named 'registered' contains data as 'true' or 'false' in the csv... i need to import this into oracle as 1 for true and 0 for false... how can i alter the control file to do this?
my control file is as follows:
INTO TABLE test
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
Apr 11, 2010 06:09 PM|mattatuni2|LINK
iv managed to solve this using decode and substr, ... does anyone have any alternative solutions?