Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 23.1: CLOB view truncate long strings with new lines

I vanApr 28 2023 — edited Apr 28 2023

CLOB view show only first 75 symbols, export from resultset also will be truncated.

Maybe it's only in Mac OS version but I don't think so.

select to_clob('loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo???') clob_string
from dual

This post has been answered by thatJeffSmith-Oracle on Dec 15 2023
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2024
Added on Apr 28 2023
20 comments
6,326 views