working on applications and technology

When I use SQL Developer to import Excel with date format column into Oracle database. Error from the date column stop the import.

In the preview window, The date column indicate there is date format problem (Date in native language).

So I go to 'Tools->Preference" menu to change the default date format.

I chanage language to 'english' and region to 'America' and I could see in the SQL Developer window that the NLS parameters for current connection have been changed.

But the import data 'preview window' still have the same date column which is still in my native language.

It seems the data import use different connection that 's not controled by the preference setting.

Change SQL Developer user interface language to solve the problem

After the Installation, SQL Developer 1.5 automatically recognize windows 's character set and use window's character set as the default user interace language. I think that this might be related with the problem.

I start to change SQL Developer 's interface language. There 's no parameter in the preference to control the user interface launage.

I have to change it in the SQL Developer configuration file. which reside under directory of 'sqldeveloper\sqldeveloper\bin'.

Just open the file and add the following:

AddVMOption -Duser.language=en


AddVMOption -Duser.country=US

Now reopen SQL Developer and the user interface is totally english now!

When importing Excel file. the date column now looks like:

Now I solve this date format problem, which is more like a bug for not reading preference setting when starting data import session.