Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Views with Column type as CLOB

614586Jan 11 2011 — edited Jan 11 2011
I have a table which has a column of type CLOB. I am trying to creating a view which has all the columns of that table.
I get

Warning: View created with compilation errors.

SQL> show errors;
No errors

Can any one help me how to create a view on a table wihich has a CLOB/BLOB column types. Also how to select the clob data from the view
--
sree
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2011
Added on Jan 11 2011
2 comments
556 views