VIEW: SYS.NLS_INSTANCE_PARAMETERS

Source

View Text - Preformatted

select substr(upper(name), 1, 30),
       substr(value, 1, 64)
from v$system_parameter
where name like 'nls%' and
      (con_id = 0 or
       con_id = (select sys_context('userenv', 'con_id') from dual))

View Text - HTML Formatted

SELECT SUBSTR(UPPER(NAME)
, 1
, 30)
, SUBSTR(VALUE
, 1
, 64) FROM V$SYSTEM_PARAMETER WHERE NAME LIKE 'NLS%' AND (CON_ID = 0 OR CON_ID = (SELECT SYS_CONTEXT('USERENV'
, 'CON_ID')
FROM DUAL))