OraFAQ Forum: German » datum in pl/sql

Home » Non-English Forums » German » datum in pl/sql

Fri, 10 June 2005 07:50

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';

Fri, 10 June 2005 08:35

Frank Naude
Messages: 4571
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

Fri, 10 June 2005 08:46

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: Tue Jan 31 21:20:49 CST 2023