Convert CLOB to VARCHAR, nvarchar, etc
I have users that need to query a table that has a CLOB column. They have to use BRIO to query. However, BRIO can NOT query CLOB datatypes.
What can I do to facilitate this?
I was thinking of creating a view. Or, I can duplicating the table into one that converts into one with a varchar datatype (since they just query for reporting).
In either case, I would have to know how to convert a CLOB into another datatype (preferrably, varchar).
One: could someone tell if I can convert it that datatype in creating the view?
Two: how would I go about converting the column (in any way possible)?