添加列

原创于 2010-11-10 18:51:00 发布 · 604 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#table #server #action #email #list

DB - Oracle 专栏收录该内容

39 篇文章

订阅专栏

alter table AGT_AGENT_MST DROP COLUMN MAIL_SERVER_TYPE;
alter table AGT_AGENT_MST_temp DROP COLUMN MAIL_SERVER_TYPE;
alter table aud_AGT_AGENT_MST DROP COLUMN MAIL_SERVER_TYPE;

alter table AGT_AGENT_MST add MAIL_SERVER_TYPE VARCHAR2(20);
alter table AGT_AGENT_MST_temp add MAIL_SERVER_TYPE VARCHAR2(20);
alter table aud_AGT_AGENT_MST add MAIL_SERVER_TYPE VARCHAR2(20);

alter table AGT_AGENT_MST_temp add TEMP_ACTION CHAR(1);
update AGT_AGENT_MST_temp set TEMP_ACTION=action;

alter table aud_AGT_AGENT_MST add TEMP_ACTION CHAR(1);
update aud_AGT_AGENT_MST set TEMP_ACTION=action;

ALTER TABLE AGT_AGENT_MST_temp drop column ACTION;
ALTER TABLE aud_AGT_AGENT_MST drop column ACTION;

ALTER TABLE AGT_AGENT_MST_temp rename column TEMP_ACTION to action;
ALTER TABLE aud_AGT_AGENT_MST rename column TEMP_ACTION to action;

alter table AGT_EMAIL_LIST drop column MAIL_SERVER_TYPE;
alter table AGT_EMAIL_LIST add MAIL_SERVER_TYPE VARCHAR2(20);