COL NLS_CHARSET_ID FOR 9999
COL NLS_CHARSET_NAME FOR A30
COL HEX_ID FOR A20
SELECT NLS_CHARSET_ID(VALUE) NLS_CHARSET_ID, VALUE NLS_CHARSET_NAME,
TO_CHAR(NLS_CHARSET_ID(VALUE),'XXXX') HEX_ID
FROM V$NLS_VALID_VALUES
WHERE PARAMETER = 'CHARACTERSET'
ORDER BY NLS_CHARSET_ID(VALUE)
/