how to know the character set of an oracle databes

Solutions on MaxInterview for how to know the character set of an oracle databes by the best coders in the world

showing results for - "how to know the character set of an oracle databes"
Andrea
18 Mar 2018
1SELECT * FROM nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
2SELECT * FROM v$nls_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
3-- NLS_CHARACTERSET for VARCHAR2, NLS_NCHAR_CHARACTERSET for NVARCHAR2
4SELECT * FROM database_properties WHERE PROPERTY_NAME
5    IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
Angelo
21 Mar 2018
1select * from database_properties where PROPERTY_NAME in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'