datatype/filtering question in control file sql*loader

[crsdev]

Hello Friends,
Can someone please help me with the function of replacing a string in control file of sql*loader.
example:
if the string in the .txt file is "null"
i want to replace that in the table with value (null)

Thanks in advance.

 

[LKBrwnDBA]

Check out the NULLIF option in SQL*Loader:

LOAD DATA
  INFILE 'emp.dat'
  INTO TABLE emp
 (empno 
 ,ename
 ,job          NULLIF job='Null'  
 ,mgr  
 ,sal  
 ,comm 
 ,deptno
  )

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb