Convert LONG datatype to VARCHAR2

Who knows a function that convert long to varchar2?

I need this because I want to do the following SQL statement to work:

Select C1 from T1
union
Select C2 from T2

Where C1, C2 are of LONG data type.

Thanks,

Petre Received on Wed Oct 28 1998 - 17:39:04 CST