Wednesday, March 13, 2013

How to set NLS_DATE_FORMAT Date format in PLSQL



declare
..
..
begin
EXECUTE IMMEDIATE 'alter session  set NLS_DATE_FORMAT=''DD-MM-YYYY''';
..
..
end;


No comments:

Post a Comment