Convert LONG 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 Thu Oct 29 1998 - 14:11:53 CST