varchar2 to blob

Can anybody let me know how to convert a varchar2 column to blob column.


Thanks

I was able to convert it by first converting to RAW (hextoraw) then convert it BLOB (to_blob).

The thing now is how do I view the blob data and make sure that I was able to convert it right.