Gangmax Blog

My Tip 54

使用Oracle的alter table语句添加字段(from here):

1
2
3
4
5
ALTER TABLE WORKLOG ADD CREATION_SOURCE varchar2(50 char);
ALTER TABLE WORKLOG ADD LOG_SUMMARY varchar2(400 char);

COMMENT ON COLUMN WORKLOG.LOG_SUMMARY IS 'worklog summary';
COMMENT ON COLUMN WORKLOG.CREATION_SOURCE IS 'worklog creation source: Automatic or Manual';

Comments