How to use two functions for a column in control file [message #294955] |
Mon, 21 January 2008 00:38 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Hi,
I want to do two operations in a single column while loading data from csv to oracle. In control file,
accNo "translate(:accNo, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWVUTSRQPONMLKJIHGFEDCBA9876543210')",
This is working fine. But incase of '?' in that field, I have to replace it with null.
I tried this.
accNo "translate(:accNo, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWVUTSRQPONMLKJIHGFEDCBA9876543210')" "replace(:accNo, '?',NULL)",
This won't work. I want to translate and incase of '?' I want to use replace it with null.
Please advice.
|
|
|
|