I am using Oracle 8.1.6i for Linux (Redhat 6.2).
I would like to alter NLS_DATE_FORMAT. As I modified initsid.ora, e.g.
NLS_DATE_FORMAT = "yyyymmdd"
when I type "Select sysdate from dual", it only shows "DD-MON-YY". And I've checked parameter by using "show parameters". I found that nls_date_format is updated. What's wrong with it?