Hi Community,
I currently try to import some delimited files to an SQL table via the Import Wizard (Right Click on a Table "Import Data...") with delimited files as Input (.dsv).
In Step 4 of the Wizard, I have to match the Source Columns of the Files to the target Columns of the Table.
Now here lies my problem. Whenever a target column has the format "date", I have to define the desired translation mask for every date column.
I would like to define a Default Mask so that the same format is always used.
From the UI, it looks like this field also exists:
However I cannot set it in the Wizard itself, and I am not able to find the option in the preferences.
I've tried the following preferences (Oracle SQL Developer 4.0.2):
Preferences-->Database-->NLS --> all 3 date preferences set to "HH24:MI:SS DD.MM.YYYY"
Preferences-->Migration-->Translators --> Default Source Date Format set to " HH24:MI:SS DD.MM.YYYY"
Preference --> Migration --> Data Move Options -->
But still, I have to type it in every time.
Can someone explain how to set the default?