Search notes:

Oracle: Globalization (NLS) related functions

Globalization (NLS) related SQL functions include

NLS_CHARSET_ID / NLS_CHARSET_NAME

nls_charset_id returns a character set's CSID (which is used, for example, in dbms_lob.loadclobfromfile)

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