Shulou(Shulou.com)06/01 Report--

The specific operations are as follows:

The original field bookdetails is varchar2 (4000), and the original table already has business data.

ALTER TABLE test

ADD (bookdetails01 CLOB)

UPDATE test SET bookdetails01=bookdetails

COMMIT

ALTER TABLE test DROP COLUMN bookdetails

ALTER TABLE atable

RENAME COLUMN bookdetails01 TO bookdetails

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.