Hi,
i want to convert the date format . The default date format in oracle is dd-mon-yy. I want that my default date format should be dd-mon-yyyy. I tried changing initorcl.ora . But it does not work.
e.g:-whenever i write "select sysdate from dual". The date format is dd-mon-yy. I want that this date format should be dd-mon-yyyy.

thankx in advance.