I have a large table that has 4 BLOB columns plus.

I need to be able to convert these blob columns to hex and display them in a view.

Is that possible?

Is there a function that I can call that will convert these blob columns to a format that is displayable by sql*plus?

Any suggestions would be helpful.

Thanks,

Dee