Answer by HillbillyToad ·
Let's say you wanted to store the contents of a magazine article in a table column. VARCHAR2 would most likely fall short. CLOB on the other hand (Character Large Object) handles the task just fine.
Or let's say you wanted to store your iTunes collection of MP4's in a table. BLOB (Binary Large Object) handles this just fine as well.
NCLOB, NVARCHAR2, N... allows you to store data in a different characterset than normal. That's better discussed as a separate topic.
There are storage implications in using LOB's if that's of interest to you.