Oracle查询某个表是否有某个列

1. 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);