public static bool ExistColumn(string tableName, string columnName, string connStr)
{
using (OracleConnection conn = new OracleConnection(connStr))
{
try
{
bool blnRet = false;
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select count(1) from USER_TAB_COLUMNS where table_name=:tablename and column_name=:columnname";
OracleParameter param = cmd.Parameters.Add(":tablename", OracleDbType.Varchar2);
param.Value = tableName.ToUpper();
param = cmd.Parameters.Add(":columnname", OracleDbType.Varchar2);
param.Value = columnName.ToUpper();
object obj = cmd.ExecuteScalar();
if (obj != null && obj != DBNull.Value)
{
if (Convert.ToInt64(obj) > )
{
blnRet = true;
}
}
conn.Close();
return blnRet;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
}