1GRANT SELECT_CATALOG_ROLE TO my_user; -- to read V$PARAMETER
2
3SELECT NAME, VALUE, DESCRIPTION FROM V$PARAMETER
4--WHERE upper(NAME) = 'NLS_DATE_FORMAT'
5ORDER BY NAME;
6
7ALTER SESSION SET
8 NLS_LANGUAGE='AMERICAN'
9 NLS_TERRITORY='AMERICA'
10 NLS_CALENDAR='GREGORIAN'
11 NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';