Create view of Remote table with CLOB column
After trying different ways of creating the view, (including using to_char() and NVL2() on the clob column) I created a materialized view which pulled the data no problem.
I really want to create a simple view of this table since the data really needs to be as real-time as possible.
Any suggestions?
Thanks,
Faith