in Oracle 9.2, how to compare LONG Type containing String text to a Column of VARCHAR2 -

In simple q oracle 9.2, compare the long type of string text to the column of VARCHAR2.

Select Table 1 from T1, Table 2 T2 Where t1.long_value = t2.varchar2_value

How do I make such a query the easiest way Can I execute?

Can not answer short, look for a function to see varchar2 change directly So that you can use it in SQL statement. There is more trouble than it has been for a long time, but sometimes you get stuck with it.