NCLOB columns vs NVARCHAR in oracle database
===

I have to store variable length texts in an oracle table. The most of them will be less than 200 chars, but some of them ocasionally will have thousands of characters.

I'm tempted to define the column as NCLOB, as this datatype stores up to 4 GB, but I wonder what would be the problem in doing so as in the 98% of the times a NVARCHAR column would be enought.

The values will not change frecuently once inserted.

Thanks