Convert CLOB column to VARCHAR2 data type
618523Jan 18 2008 — edited Jan 18 2008My knowledge of writing SQL code for Oracle doesn't go far beyond creating basic tables and relationships. I have a situation where I need to convert a column in a table with data in it from CLOB to VARCHAR2. While I know this statement does not work, I would essentially like to accomplish this:
ALTER TABLE table1
MODIFY clob_column VARCHAR2(1000);
This needs to be done with SQL code in SQL*Plus. The Oracle version is 9i. I am guessing I would need to create the VARCHAR2 column and then somehow move the data over and then drop the CLOB column. An example of how you would accomplish this in SQL*Plus would be greatly appreciated. Thanks!