Oracel加删改查常用操作

Oracel添删改查常用操作

?

?

?

?

数据库表中添加一字段：

?

?

alter? table CASE_COMPARE_RESULT_INFO add?? identify_status? varchar2(10);

alter? table?? CASE_COMPARE_RESULT_INFO?? add? recheck_person?? varchar2(64);

comment on column? case_compare_result_info.identify_status? is? '亲缘比对鉴定状态';

comment on column case_compare_result_info.recheck_person? is? '复核人';

commit;