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'