Oracle: Globalization (NLS) related functions

NLS_CHARSET_ID / NLS_CHARSET_NAME

select nls_charset_id('we8mswin1252') from dual;
-- 178
   
select nls_charset_name(178) from dual;
-- WE8MSWIN1252

See also