Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter session set NLS_DATE_FORMAT = 'yyyy-MM-dd HH24:MI:SS'

Harsh_vJan 6 2014 — edited Jan 6 2014

Hi experts,

when i login from any Oracle user found "alter session set NLS_DATE_FORMAT = 'yyyy-MM-dd HH24:MI:SS'" every time.

I think someone change some setting in DB. I not understand how work it and what is that means its "trigger" or something else.

please help me find out this issue

[oracle@server~]$ sqlplus mcarbon/mcarbon@orcl

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 6 12:08:22 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Session altered.

SQL> ;

  1* alter session set NLS_DATE_FORMAT = 'yyyy-MM-dd HH24:MI:SS'

Reg,

Harsh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2014
Added on Jan 6 2014
1 comment
28,928 views