VIEW: SYS.NLS_SESSION_PARAMETERS

Source

View Text - Preformatted

select substr(parameter, 1, 30),
       substr(value, 1, 64)
from v$nls_parameters
where parameter != 'NLS_CHARACTERSET' and
 parameter != 'NLS_NCHAR_CHARACTERSET'

View Text - HTML Formatted

SELECT SUBSTR(PARAMETER
, 1
, 30)
, SUBSTR(VALUE
, 1
, 64) FROM V$NLS_PARAMETERS WHERE PARAMETER != 'NLS_CHARACTERSET' AND PARAMETER != 'NLS_NCHAR_CHARACTERSET'