ORACLE 中添加字段

1 判断某表中是否有某字段

 select count(column_name)   from cols  where table_name = upper('tbl_archiverequest')  
and column_name = upper('updatedate')

 

2 添加字段

alter table tbl_archiverequest add  UpdateDateTime date;