Skip to Main Content
  • Questions

  • Alternative for CLOB data type in oracle 12g

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, leon.

Asked: August 04, 2017 - 7:18 am UTC

Last updated: August 05, 2017 - 2:41 am UTC

Version: 12c

Viewed 1000+ times

You Asked

I wanted to know what is the best alternative data type for CLOB? My current database have a few CLOB data type.

Does CLOB Data type is going to be deprecated in newer version?

I tried to search around and seems like varchar2 will be the alternative but it has a limit size of 4000 which is not enough for me. Any expert can advise me on this? Thank you very much!

and Connor said...

I've heard nothing to suggest CLOB is going away....ever.

What is your objection to CLOB ? For large text (>4k) CLOB is the way go.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database