How to change column varchar to clob in oracle?

(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.

1 If we're doing this in a single session the COMMIT is unnecessary, as the subsequent ALTER TABLE statement issues an implicit commit (two, actually). – APC Jul 27 at 8:16.

Add a clob column to the table update clob column with values from varchar column drop varchar column rename clob column to varchar columns name.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.