Home » RDBMS Server » Server Utilities » SQL loader null and datatype
SQL loader null and datatype [message #187210] Fri, 11 August 2006 05:38
Messages: 65
Registered: November 2001
I have datafile like

2039380,GB5444,AT8000,NZD,123456789.00,07Mar02,INVOICE REFERNCE VVVVVVV,10Feb02,,,GBP,35857082.52,0.2904424,01,1
2039382,GB4444,AT8000,GBP,674.13,17Mar02,INVOICE REFERNCE,02Feb02,,,GBP,674.13,1,01,1

I am facing two issue
1. There is one field , which carry - sign , thus sqlloader rejects,the column does have datatype number(12,2) and in loader this datatype i decxlare is decimal external.

2. There is few column which does not have any data,thus they aslo get rejected

can anyone point, is there any way to bypass the null value against that column and what would be datatype for -ve sign value.

Third Does SKIP=1 means no lodaing for first row from data file

thanks in advance
Previous Topic: Error with SQL Loader import file in Oracle 10G
Next Topic: Split record in SQL*Loader
Goto Forum:

Current Time: Wed Jun 28 16:10:51 CDT 2017

Total time taken to generate the page: 0.11634 seconds