Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

convert clob to long varchar

User_AC3QEJun 15 2020 — edited Jun 15 2020

Hi

I changed a field that was varchar to Clob, but, I will have to change the Clob field to type Long with 4000 more for report export,

how to make?

SELECT       rtrim(xmlcast(xmlagg(xmlelement(e,'column > 4000','  ')) as clob),',')  dispositivo from dual

Comments
Post Details
Added on Jun 15 2020
6 comments
1,401 views