How to check the Oracle database character set

In this tutorial, How do I use to check the Oracle query Database character set? Use “NLS_CHARACTERSET” and “NLS_NCHAR_CHARACTERSET” in the Oracle database.

Check the Oracle database character set

SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE from database_properties WHERE PROPERTY_NAME ='NLS_CHARACTERSET';

The screen output terminal

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ --------------
NLS_CHARACTERSET               AL32UTF8

SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE from database_properties WHERE PROPERTY_NAME ='NLS_NCHAR_CHARACTERSET';

The screen output terminal

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ --------------
NLS_NCHAR_CHARACTERSET         AL16UTF16

Conclusion

Through the article, you can “Check the Oracle database character set” as above. I hope will this your helpful. Thank you for reading the DevopsRoles page!