DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Nov 1999

    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


  2. #2
    Join Date
    Jun 2002
    Longmont, Colorado
    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?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.