ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US B64B86A4545F41E6E0530100007F94B8 select '0' level_, lower(do.owner||'.'||do.object_name) object, do.owner, do.object_name, do.object_type, lower(do.owner||'.'||do.object_name) path from dba_objects do where do.owner=:owner and do.object_name=:object_name and do.object_type=:object_type and 1=1 union all select lpad(' ',2*(level))||level level_, lower(lpad(' ',2*(level))||dd.owner||'.'||dd.name) object, dd.owner owner, dd.name object_name, dd.type object_type, substr(lower(xxen_util.reverse(sys_connect_by_path(dd.owner||'.'||dd.name,' > '),' > ')||' > '||:owner||'.'||:object_name),4) path from dba_dependencies dd where dd.owner not in ('SYS','SYSTEM','PUBLIC') and dd.referenced_owner not in ('SYS','SYSTEM','PUBLIC') and dd.referenced_type<>'NON-EXISTENT' connect by nocycle prior dd.owner=dd.referenced_owner and prior dd.name=dd.referenced_name and prior dd.type=dd.referenced_type start with dd.referenced_owner=:owner and dd.referenced_name=:object_name and dd.referenced_type=:object_type Y AR DBA Dependencies (used by) تقرير هرمي يعرض جميع كائنات قاعدة البيانات باستخدام كائن محدد D DBA Dependencies (used by) Hierarchischer Bericht, der alle Datenbankobjekte anzeigt, die ein bestimmtes Objekt verwenden E DBA Dependencies (used by) Informe jerárquico que muestra todos los objetos de la base de datos que utilizan un objeto especificado F DBA Dependencies (used by) Rapport hiérarchique montrant tous les objets de la base de données utilisant un objet spécifique I DBA Dependencies (used by) Rapporto gerarchico che mostra tutti gli oggetti del database che usano un oggetto specificato JA DBA Dependencies (used by) 指定されたオブジェクトを使用して、すべてのデータベースオブジェクトを表示する階層レポート KO DBA Dependencies (used by) 지정된 개체를 사용하는 모든 데이터베이스 개체를 보여주는 계층 적 보고서 PTB DBA Dependencies (used by) Relatório hierárquico mostrando todos os objetos do banco de dados usando um objeto especificado RU DBA Dependencies (used by) Иерархический отчет, показывающий все объекты БД с использованием указанного объекта S DBA Dependencies (used by) Hierarkisk rapport som visar alla databasobjekt med ett angivet objekt TR DBA Dependencies (used by) Belirtilen bir nesneyi kullanan tüm veritabanı nesnelerini gösteren hiyerarşik rapor US DBA Dependencies (used by) Hierarchical report showing all database objects using the specified object, e.g. a certain table and the report shows all the views or packages that are refrencing or depending on the specified table (bottom to top) ZHS DBA Dependencies (used by) 分层报告，显示所有使用指定对象的数据库对象。 Enginatics 1=1 :object_name :object_type :owner 1 10 :owner LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username APPS Y US Owner 2 20 :object_type LOV custom Y select 'EVALUATION CONTXT' value, null description from dual union all select 'FUNCTION' value, null description from dual union all select 'INDEXTYPE' value, null description from dual union all select 'JAVA CLASS' value, null description from dual union all select 'LIBRARY' value, null description from dual union all select 'MATERIALIZED VIEW' value, null description from dual union all select 'OPERATOR' value, null description from dual union all select 'PACKAGE BODY' value, null description from dual union all select 'PACKAGE' value, null description from dual union all select 'PROCEDURE' value, null description from dual union all select 'SEQUENCE' value, null description from dual union all select 'SYNONYM' value, null description from dual union all select 'TABLE' value, null description from dual union all select 'TYPE' value, null description from dual union all select 'VIEW' value, null description from dual union all select 'XML SCHEMA' value, null description from dual SYNONYM Y US Object Type 3 30 :object_name LOV custom Y Y select do.object_name value, do.object_type||': '||do.owner||'.'||do.object_name description from dba_objects do where do.owner=:$flex$.owner and do.object_type=:$flex$.object_type Y US Object Name :$flex$.object_type Object Type Object Name :$flex$.owner Owner Object Name