Question: how to change nls_date_format in oracle 11g?
Answer: Step 1: Go to Tools > Preferences. Figure 4. Select Tools > Preferences.
Step 2: Click Database > NLS. Figure 5. Go to Database > NLS.
Step 3: Update the value in Date Format field: Figure 6. Oracle set nls_date_format using SQL Developer.