Question: how to set date format in oracle sql?
Answer: From Oracle SQL Developer's menu go to: Tools > Preferences.
From the Preferences dialog, select Database > NLS from the left panel.
From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.
Save and close the dialog, done!