Hi all, we are trying to load this file that contains NULL values. SQLLDR ignores the NULLs and moves the next field over. In other words, it replaces the NULL value with the value that is following it. Here is an example, let say I have the following format:
What SQLLDR does makes the above record:
How can I go around this? I don't want to replace the NULL with another value, what I want is to somehow make SQLLDR to see the NULL. Thank you.