I have a table with LONG type column. Can anyone send me code for converting LONG value into Varchar2 value in oracle8i.

Table Structure:- TEST
Column Name Data Type
--------------- ---------------
C1 NUMBER
C2 LONG RAW

Thank you in advance.
Regards
Bhaskara