Oracle character set

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');

Source: grepper.com

Similar codes

2 votes335 views2 answers
Postgres drop column if exists
SQL
1 vote323 views1 answer
Oracle create index if not exists
SQL
0 vote323 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote339 views1 answer
Drop-toys-table
SQL
0 vote339 views1 answer
Xamarin sql lite create table if not exist
SQL
8 votes374 views6 answers
Sql insert
SQL
0 vote330 views1 answer
Mysql terminal run sql file
SQL
0 vote315 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote322 views1 answer
Dasebase_url-postgres for windows
SQL
-2 votes341 views2 answers
Union all in sql
SQL