function getDatas($user = FALSE)
{
$sql = "SELECT MIN_VALUE, MAX_VALUE, INCREMENT_BY, " . "CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE, LAST_NUMBER, SEQUENCE_NAME " . "FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER='%s'";
$this->setDatasSql($sql);
Object::getDatas($user);
}
function getDatas($user = FALSE)
{
$sql = "SELECT view_name, comments FROM all_views, all_tab_comments WHERE " . "all_views.owner = '%s' AND all_views.owner = all_tab_comments.owner(+) " . "AND all_views.view_name = all_tab_comments.table_name(+) " . "ORDER BY view_name";
$this->setDatasSql($sql);
Object::getDatas($user);
}
function getDatas($user = FALSE)
{
$sql = "SELECT object_name, TO_CHAR(created, 'DD-MON-YYYY') CREATED, " . "TO_CHAR(last_ddl_time, 'DD-MON-YYYY') LASTMODIFIED, NLS_INITCAP(status) status FROM all_objects " . "WHERE owner = '%s' AND object_type='FUNCTION' ORDER BY object_name";
$this->setDatasSql($sql);
Object::getDatas($user);
}
function getDatas($user = FALSE, $name = FALSE)
{
$sql = "SELECT object_name, TO_CHAR(created, 'DD-MON-YYYY') CREATED, " . "TO_CHAR(last_ddl_time, 'DD-MON-YYYY') LASTMODIFIED, NLS_INITCAP(status) STATUS " . "FROM all_objects WHERE object_type ='PROCEDURE' AND " . "owner = '%s' ORDER BY object_name";
$this->setDatasSql($sql);
Object::getDatas($user);
}
function getDatas($user = FALSE, $name = FALSE)
{
$sql = "SELECT t.TABLE_NAME TABLE_NAME, t.TABLESPACE_NAME TABLESPACE_NAME, t.CLUSTER_NAME CLUSTER_NAME, " . "t.OWNER OWNER, c.comments comments FROM ALL_TABLES t, all_tab_comments c WHERE t.OWNER='%s' " . "AND t.owner = c.owner AND t.table_name = c.table_name ORDER BY t.TABLE_NAME";
// set last showed query
$GLOBALS["SQL_QUERY_TO_SHOW"] = $sql . ";";
$this->setDatasSql($sql);
Object::getDatas($user);
$count = count($this->datas[$user]);
for ($x = 0; $x < $count; $x++) {
$sql = "SELECT count(*) FROM " . $this->datas[$user][$x]["OWNER"] . "." . $this->datas[$user][$x]["TABLE_NAME"];
$this->parse($sql);
$this->execute();
$result = $this->nextrow();
$this->datas[$user][$x]["Entries"] = $result["COUNT(*)"];
}
}
function getDatas($user = FALSE, $name = FALSE)
{
$sql = "SELECT trigger_name, trigger_type || triggering_event TYPE, " . "table_owner, table_name, status FROM all_triggers " . "WHERE owner = '%s' ORDER BY trigger_name";
$this->setDatasSql($sql);
Object::getDatas($user);
}
function getDatas($user = FALSE)
{
$sql = "SELECT index_name, index_type, table_owner, table_name FROM all_indexes " . "WHERE owner = '%s' ORDER BY index_name";
$this->setDatasSql($sql);
Object::getDatas($user);
}
