Hi Friends,

I want to set my sysdate as DD-MM-YYYY in oracle8i.
I did using alter session set NLS_DATE_FORMAT='DD-MM-YYYY';
This is session dependent.
I want to set it for the database instance.Let me know where should i set this option in oracle 8i.
I tries setting in init.ora file, but it is not taking.


Thank you
Mahesh Kumar BK

I think you maybe use spfile