Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with date format !!!! urgent

Re: help with date format !!!! urgent

From: News <Contact_404_at_hotmail.com>
Date: Tue, 12 Jun 2007 02:06:46 -0700
Message-ID: <1181639206.980134.205180@j4g2000prf.googlegroups.com>


I resolved temporary the problem using trigger

create or replace trigger logon_trigger
after logon on database
declare
 xOsUser varchar2 (30);
 xSid number;
begin

   execute immediate 'Alter session Set NLS_DATE_FORMAT = "YYYY-MM- DD"';
end;
/ Received on Tue Jun 12 2007 - 04:06:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US