The best replacement for clob is varchar2.

The best alternatives to clob are rated as following:
★★★★★  varchar2
★★★★★  blob
★★★★  varchar
★★★  nclob
★★  xmltype
★★  rfq
★★  blob db2
★  blob sql server
★  varchar2 oracle
★  blob mysql
  long varchar

Your alternative for clob is not listed? Suggest!
Speaking about clob, one probably shouldn't forget about sqlldr.

Other search terms related to clob and their ratings are:
★★★★★ sqlldr
★ listagg
You have in mind a companion for clob and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of clob in all years. Click on graph for more.
clob
varchar2
blob