Convert Clob column to Varchar2 column?
513973Aug 1 2006 — edited Aug 1 2006I need to convert a Clob column to a Varchar2 column. I can't find any easy methods to do this. Is there a simple SQL type command I can use to convert the column? I found that a simple ALTER TABLE does not work - shows an error message saying that the modification cannot be done with this field.
Help! All data in the Clob fields is under 4000 characters long.
dailysun