Skip to Main Content

SQL & PL/SQL

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!

how to convert BLOB column data into readable text format.

User_LR8CDDec 12 2022

I need to get blob column data into readable text format but while converting it into text it shows many junc/unreadable special character in sql developer. same is showing when i try to return it using sql query.
Ex: "úÿÿÿÿÿ QÎ ÈEè>

image.pngNote: Black Hidden part is few readable data which is correct but cant read other one which highlighted in yellow.

please help with any query which can convert all blob into proper readable text.

Comments
Post Details
Added on Dec 12 2022
4 comments
4,953 views