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 vote67 views2 answers
Procedure pl/sql
SQL
1 vote91 views4 answers
Between vs in sql
SQL
0 vote98 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote99 views1 answer
Add column not null with default value postgres
SQL
3 votes101 views4 answers
Show sql server database
SQL
1 vote110 views1 answer
Age postgres
SQL
1 vote108 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote99 views1 answer
Mariadb LOAD DATA INFILE
SQL
7 votes103 views1 answer
Set sequence value oracle
SQL
5 votes103 views1 answer
Sql check if date is between 2 dates
SQL