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;

转载于:https://www.cnblogs.com/deanc/archive/2013/04/24/3039882.html