17,140
社区成员




CREATE TABLE table2 AS SELECT * FROM T_REPOSITORY_INDEX
truncate table T_REPOSITORY_INDEX
ALTER TABLE table1 modify B varchar2(200)
INSERT INTO T_REPOSITORY_INDEX
(PK_AUTO_ID,
UK_FILE_ID,
TITLE,
CONTENT,
TYPE,
LEVEL_ID,
POST_USER_NAME,
UPDATE_TIME,
OPE_CODE,
ANNEX)
SELECT PK_AUTO_ID,
UK_FILE_ID,
TITLE,
CONTENT,
TO_CHAR(TYPE),
LEVEL_ID,
POST_USER_NAME,
UPDATE_TIME,
OPE_CODE,
ANNEX
FROM table2
SQL> update T_REPOSITORY_INDEX set type=null;
2 rows updated
SQL> alter table T_REPOSITORY_INDEX modify type varchar2(200) ;
Table altered