Answers for "oracle sql variable session"

oracle session variables list

GRANT SELECT_CATALOG_ROLE TO my_user;	-- to read V$PARAMETER 

SELECT NAME, VALUE, DESCRIPTION FROM V$PARAMETER 
--WHERE upper(NAME) = 'NLS_DATE_FORMAT' 
ORDER BY NAME;

ALTER SESSION SET 
	NLS_LANGUAGE='AMERICAN' 
    NLS_TERRITORY='AMERICA' 
    NLS_CALENDAR='GREGORIAN'
    NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';