I want to concatenate two columns from my spreadsheet into a single column on my target Oracle table when running Import Table Data.
e.g.
Spreadsheet Table Column in Oracle
--------------- ---------------------------
Col1 || Col2 => Col (Concat Col1 & Col2 during mapping in Import Table Data)
There are no concatenation operator in the Expression Builder for the Import Table Data.
WORKAROUND:
None.
STATUS:
Enhancement request QCM34614 has been submitted to Development for consideration in a future release of Toad for Oracle.