How to change column varchar to clob in oracle

sql oracle oracle10g
Whtisop picture Whtisop · Jul 27, 2011 · Viewed 52.9k times · Source

I have a column details designed as varchar in oracle DB, this DB is being used now for customers and some rows already have data stored.

Now I want to change the column details to a Clob column. What is a smart way to accomplish this？

Answer

Kevin Burton picture Kevin Burton · Jul 27, 2011

(as the previous answer) and here's the code:

ALTER TABLE atable
 ADD (tmpdetails  CLOB);

UPDATE atable SET tmpdetails=details;
COMMIT;

ALTER TABLE atable DROP COLUMN details;

ALTER TABLE atable
RENAME COLUMN tmpdetails TO details;

Related questions

CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More
How to insert date values into table

How can I insert into table with different input using / ,with date datatype? insert into run(id,name,dob)values(&id,'&name',[what should I write here?]); I'm using oracle 10g.

Read More
ORA-01861: literal does not match format string

When I try to execute this snippet: cmd.CommandText = "SELECT alarm_id,definition_description,element_id, TO_CHAR (alarm_datetime, 'YYYY-MM-DD HH24:MI:SS'),severity, problem_text,status FROM aircom.alarms WHERE status = 1 and TO_DATE (alarm_datetime,'DD.MM.…

Read More