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.