You are correct in that converting the CLOB to a character database will truncate anything over 4,000 characters. If your CLOBs are bigger than that, then you will not be able to use them in the UNION statement. You will have to employ some other work around in your application.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.