public List <ITableClass> GetTables()
{
if (_tables.Count == 0 && !_isLoadTabs)
{
string sql = "select a.table_name,a.tablespace_name,a.pct_free,a.pct_used,a.pct_increase,a.ini_trans,a.max_trans,a.initial_extent,a.next_extent,a.min_extents,a.max_extents,a.buffer_pool,b.comments from user_tables a left join user_tab_comments b on a.table_name=b.table_name order by a.table_name";
DataTable dt = _oracleHelper.ExecuteDataTable(sql);
foreach (DataRow item in dt.Rows)
{
OracleTableClass otc = new OracleTableClass(item);
otc.SetOracleHelper(_oracleHelper);
_tables.Add(otc);
}
_isLoadTabs = true;
}
List <ITableClass> t = new List <ITableClass>();
t.AddRange(_tables);
return(t);
}
public List<ITableClass> GetTables()
{
if (_tables.Count == 0 && !_isLoadTabs)
{
string sql = "select a.table_name,a.tablespace_name,a.pct_free,a.pct_used,a.pct_increase,a.ini_trans,a.max_trans,a.initial_extent,a.next_extent,a.min_extents,a.max_extents,a.buffer_pool,b.comments from user_tables a left join user_tab_comments b on a.table_name=b.table_name order by a.table_name";
DataTable dt = _oracleHelper.ExecuteDataTable(sql);
foreach (DataRow item in dt.Rows)
{
OracleTableClass otc = new OracleTableClass(item);
otc.SetOracleHelper(_oracleHelper);
_tables.Add(otc);
}
_isLoadTabs = true;
}
List<ITableClass> t = new List<ITableClass>();
t.AddRange(_tables);
return t;
}
