I came across a situation where a table has to be exported into excel.
This table got two columns of clob data type.
The end users wants us to export this clob into excel but due to excel cell constraint of 32767 character limit per cell obligate us to either split it into rows or columns.
Since user anticipates to have it split in column
For example my table is Tab1 with columns (col1,col2, col3, col4) where col3 and col4 is clob datatype and lenght of col3 is 819175 and 1671117 where col1 is unique identifier and col2 have a text value