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); }