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: Oracle 8.0.5 and Date formats

Re: Oracle 8.0.5 and Date formats

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 3 Mar 1999 07:17:22 +0100
Message-ID: <36dcd3f9$0$13304@pascal> 





Thomas Kyte wrote


>in 8.1 and above you are able to


>create or replace trigger data_logon_trigger


>after logon


>ON DATABASE



>begin


>    execute immediate


>        'alter session set nls_date_format = ''yyyy-mm-dd'' ';


>end;


>/






Wow! Now that is a good point to read the whitepapers and upgrade asap!



Arjan.


Received on Wed Mar 03 1999 - 00:17:22 CST












Original text of this message













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