How to check the database character set and NLS parameters in Oracle

NLS_DATABASE_PARAMETERS captures the database-wide NLS settings that were fixed at creation time — character set, national character set, sort order, date/time formats. Compare against session NLS and expected values before importing data or moving a schema.

SELECT * FROM nls_database_parameters;