This content has been marked as final. Show 4 replies
Would it be possible to have the whole clob's contents on copy and/or export without having to edit the cell?We can but aren't inclined since the CLOB can size upto GBs. The truncation size though can be made a preference. Please open a new feature request at the exchange for this, if you like.
We would recommend living with an extra click or two compared to preferences overkill.
It used to give you the whole CLOB column, now it truncates. I don't think I'd consider having previous features available as a preference to be "preferences overkill"
I just ran into this too. A SQL script that used to export just fine no longer works.
SQL Server's Query Analyzer gives me this feature, so I think you'd strive to be at least as good as the competition ;-)
4000 seems an odd choice. If 4000 characters was sufficiently big for the data, then it would be a VARCHAR2 not a CLOB, so for most CLOBs it will be inadequate. On the other hand, 4000 is characters is too big to read on a screen field, and needs to be cut-and-pasted.
Also, if people wanted to just see the first 4000 characters, they can simply CAST(clob as VARCHAR2(4000))
How about switching from 4000 to 32K ?