Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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,325 views