Home » Non-English Forums » German » datum in pl/sql
datum in pl/sql [message #123185] Fri, 10 June 2005 07:50 Go to next message
mandy2001ir
Messages: 3
Registered: June 2005
Junior Member
Hallo,
ich will dieser Befehl in einer pl/sql Prozedur schreiben, wie kann man das machen?
alter session set nls_date_format = 'dd-mm-yyyy';
Re: datum in pl/sql [message #123194 is a reply to message #123185] Fri, 10 June 2005 08:35 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Versuchen Sie das folgende:

SQL> BEGIN
  2    EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT = ''dd-mm-yyyy''';
  3  END;
  4  /

PL/SQL procedure successfully completed.


Bester Respekt.

Frank
Re: datum in pl/sql [message #123199 is a reply to message #123194] Fri, 10 June 2005 08:46 Go to previous message
mandy2001ir
Messages: 3
Registered: June 2005
Junior Member
Danke dir vilemals, es hat funktioniert.
vlG
Mandy
Previous Topic: Oracle Call Interface "ofen"-Aufruf umgedreht
Next Topic: owa_util.ident_arr
Goto Forum:
  


Current Time: Thu Mar 28 15:23:41 CDT 2024