Create view with long datatype conversion

Is there anyway to create a view across tables and covert a long datatype to a char datatype.

eg.
create or replace view my_view as
SELECT
    a.char_data as col1, b.long_data as col2 FROM table1 a, table2 b
WHERE a.pkey = b.fkey

I am using the view in Crystal Reports which does not permit long datatypes to be used in any functions so I need col2 to be a character field.

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 18:55:35 CST