Question: what is the difference between long and clob in oracle?
Answer: Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility. Oracle also recommends that you convert existing LONG columns to LOB columns. ... Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases.