Displaying / Reading text string from a BLOB
Hello
We have a 19.18 database that has an application table and for some reason storing TEXT in a BLOB field. so like one of the column is defined as BLOB but it does not store like a media file or image or jpg file but rather all the contents are text
Is there a way we can do a select on this field in sqlplus and display the data?
Also, would it be possible to search for a text string in that feild?
Thank you in advance for your guidance and help