现在我想将列详细信息更改为Clob列.什么是聪明的方式来实现这一目标?
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;