修改字段信息
?
?
--添加ID字段alter table UTDICTIONARYT_TEMP drop column ID;alter table UTDICTIONARYT_TEMP add ID number;--创建存储过程CREATE OR REPLACE PROCEDURE TEST_TEMPINFO is cursor crs_ut is select * from utdictionaryt_temp for update; var_index_id NUMBER;BEGIN var_index_id := 1; FOR r_ut in crs_ut LOOP UPDATE utdictionaryt_temp SET id = var_index_id WHERE current of crs_ut; var_index_id := var_index_id + 1; END LOOP;END;/COMMIT;execute test_tempinfo;commit;--添加主键alter table UTDICTIONARYT_TEMP add constraint utdictionaryT_TEMP_1001 primary key (ID);commit;
?
