Hello:
Can anyone explain to me what exactly 'Alter Session' will do? Will it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session currently on?
I have following script like:
ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD-HH24.MI.SS';SELECT
Title: RE: ALTER SESSION SET NLS_DATE_FORMAT
-Original Message-
From: Wendy Y [mailto:[EMAIL PROTECTED]]
Can anyone explain to me what exactly 'Alter Session' will do?
Will it alter the session all the way until it close?
How do I find out what kind of mode is my SQLPLUS session
l it alter the session all the way until it close?
How do I find out what kind of mode is my SQLPLUS session currently on?
I have following script like:
ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD-HH24.MI.SS';
SELECT ...
FROM ...
WHERE ...
(TO_DATE(SUBSTR(KOMP.DATCRE,1,19),'-MM-DD-