Hi People,
Can you help me,
I trying to do a load by txt file , but I Have a condition "where field1 is null or Field1 =! 'ALFA' " how can I do this .
I.E.
LOADDATA
INFILE '/dir/file.csv'
APPEND
INTO TABLE TABLE_NAME
WHEN (FIELD1 IS NULL ) OR (FIELD1 != 'ALFA' )
......
How Can I do this First condition, because the Oracle 11 not accept " Is null "
I Tried Field1 = BLANKS , but always the same error .....
Tks