Oracle NLS_CHARACTERSET

SELECT * FROM nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
SELECT * FROM v$nls_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
-- NLS_CHARACTERSET for VARCHAR2, NLS_NCHAR_CHARACTERSET for NVARCHAR2
SELECT * FROM database_properties WHERE PROPERTY_NAME
    IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');

Similar codes

1 vote337 views3 answers
How to truncate table with foreign key constraint
SQL
14 votes334 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
-1 vote327 views1 answer
How to switch user in mysql
SQL
0 vote372 views1 answer
Mysql, how to query the table comments?
SQL
2 votes370 views1 answer
How to check if a row is null in sql
SQL
1 vote302 views1 answer
Mysql find tables with column name
SQL
1 vote326 views1 answer
Describe table in sql
SQL
9 votes311 views6 answers
Sql insert into
SQL
0 vote384 views1 answer
Pagination with row_number
SQL
0 vote319 views1 answer
Pgadmin see indexes
SQL