- sql语句
select count(0) as 列
from user_tab_columns
where UPPER(column_name)='RECID' AND TABLE_NAME = 'MD_ORG'
2. 写在mybatis中
//查询某个字段在某个表中是否存在 是返回1 不是返回0
@Select("select count(0) as aanum \r\n" +
"from user_tab_columns \r\n" +
"where UPPER(column_name)=#{column} AND TABLE_NAME = #{tablename}")
Integer findIfColExistInTable(String tablename,String column);