What is the difference between CLOB and NCLOB?

问题:

Can you state any difference between the CLOB and NCLOB?

回答1:

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.