/// <summary>
/// 获取Oracle数据库中所有的表名称
/// </summary>
/// <returns></returns>
public List <string> GetTableNamesOracle()
{
List <string> tblist = new List <string>();
try
{
string selectTables = @" select t.tbname,b.comments from (
select View_Name as tbname from user_views
union
select Table_Name as tbname from user_tables) t
left join USER_TAB_COMMENTS b on b.TABLE_NAME=t.tbname order by t.tbname asc";
/*OleDbDataAdapter da = new OleDbDataAdapter(selectTables, tempmyConn);
* DataTable dt = new DataTable();
* da.Fill(dt);*/
DataSet ds = DBHelperOracle.GetDataSet(selectTables);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string tname = dr["tbname"].ToString();
string comment = dr["comments"] == null ? "" : dr["comments"].ToString();
if (string.IsNullOrWhiteSpace(comment))
{
tblist.Add(tname);
}
else
{
tblist.Add(tname + "(" + comment + ")");
}
}
}
}
catch (Exception exp)
{
// TxtLogHelper.m_CreateErrorLogTxt("0", exp.Message);
}
finally
{
}
return(tblist);
}
