sqlplus建立表和comment

create table t_rush_repair
(
rush_id number not null,
input_name varchar2(50),
linetype number,
linename varchar2(50),
repair_content varchar2(200),
repair_date date,
memo varchar2(200)
);

COMMENT ON COLUMN t_rush_repair.rush_id IS '主鍵';

COMMENT ON COLUMN t_rush_repair.INPUT_NAME IS '搶修人';

COMMENT ON COLUMN t_rush_repair.LINETYPE IS '管線類型';

COMMENT ON COLUMN t_rush_repair.LINENAME IS '管線名稱';

COMMENT ON COLUMN t_rush_repair.REPAIR_CONTENT IS '搶修內容';

COMMENT ON COLUMN t_rush_repair.REPAIR_DATE IS '搶修日期';

COMMENT ON COLUMN t_rush_repair.MEMO IS '備忘';