How to view Oracle table column character set? How to view Oracle table column character set? oracle oracle

How to view Oracle table column character set?


A column doesn't have a character set in Oracle. A database has a character set and a national character set. All char, varchar2, and clob columns use the database character set. All nchar, nvarchar2, and nclob columns use the national character set.

You can see both character sets by running

SELECT *  FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET'