Hi,
I am importing some data into a table from a delimited text file. Unforturnately the text file contains NULL records:
ID|First Name|Last Name
1|John|Smith
2|Mary|White
3|Ken|Gray
My question is how can I signal to SQL Loader to ignore any null record.
Thanks for your responses...
I am importing some data into a table from a delimited text file. Unforturnately the text file contains NULL records:
ID|First Name|Last Name
1|John|Smith
2|Mary|White
3|Ken|Gray
My question is how can I signal to SQL Loader to ignore any null record.
Thanks for your responses...