When using expressions in Toad's Import Table Data, the IIF function does not import correctly.
1) Create a simple table with a varchar2 column
2) Create an input text file with number values 1 and 2 for the varchar column
3) Process the import
4) In Verify Mappings screen, select Expression in the source dropdown
5) Build an IIF expression such that the source number will be replaced with a word, i.e.:
IIF(Field1=1,'one','two')
6) Continue with import and finish (Note the import window for Preview Import will not show any value in the column that has an expression applied. You must continue and infinish the import to review this column's data)
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle.
Other expression functions should work properly. Please report if there are issues with other expression functions in Import Table Data.