Oracle has 2 place where it use date format.
server site setup using NLS_DATE_FORMAT in init$SID.ora
client site setup in:
for unix - in .profile(.login)
for Win - in register (Local Mashle---> Oracle)
sqlplus always use client site setup for NLS_DATE_FORMAT.
U haven't any errors and problem with date format.




Reply With Quote