Default Date Format

[Oracledba8]

If You want to Change the date format for the current session only then use this

Alter session set nls_date_format = 'DD-MON-YYYY';

This will help you.

Thanks..