how to convert blob type to actual text in oracle — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to convert blob type to actual text in oracle

Summary:

the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. Please suggest if there is any syntax to convert blob file to actual text.. Thank you.


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!