sql - What is the difference between CLOB and NCLOB?

Question

Can you state any difference between the CLOB and NCLOB?

question from:https://stackoverflow.com/questions/6854609/what-is-the-difference-between-clob-and-nclob

Answer 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.