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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2024

Added on Apr 28 2023

#sql-developer

20 comments

6,472 views

1 mention