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!

Formatting BLOB data result

3293652Sep 19 2016 — edited Sep 19 2016

I have a column in a table that is defined as a blob. I was able to get text into a result column by using the SQL command, utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR(field_name, 2000, 1)).

However, the result comes back formatted as Blah:Blah, blah, blah, blah, etc. I need to put this text in a report, but do not want the to appear.

Can someone help me to format the result to remove the , perhaps some addition to the SQL command that would format it properly or maybe point me to a help page for this type of issue?

Any help would be appreciated or if more information is needed I would be glad to provide.

Thanks.

This post has been answered by gdanby on Sep 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2016

Added on Sep 19 2016

5 comments

455 views