datatype problem

[puneet]

Hi

How to convert CLOB to varchar 2 or char. I am importing a table from 8.1.5 which has a clob datatype in one of teh columns and giving me a problem in export and import .So let me know if there is anything I can do

Thanks

[dbbyleo]

I have the same issue. Altough in ine, I have a table that has a CLOB column. My users are using Brio and they need to able to query this table, including this CLOB column.

However, it turns out, Brio can NOT query CLOB datatypes.

My first idea was: create a view of the table and convert the CLOB to varchar. I think that's wishful think, though. I don't think you can do any data type conversion in creating a view. Could you?

Second thougth: just duplicate the table and duplicate it with the column as varchar.

In either case, how would I convert th CLOB into varchar?

Thanks.