What is the difference between CLOB and NCLOB?

A CLOB stores character data encoded in the database character set. A NCLOB stores character data encoded in the national character set

SELECT parameter, value
  FROM v$nls_parameters
 WHERE parameter LIKE '%CHARACTERSET'

will show you the database and national character sets of your database.

Leave a Comment