ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 30032754FBE805D6E0630100007F1CAD select do.owner, do.object_name, do.subobject_name, do.object_type, do.status, do.created, to_date(substr(do.timestamp,1,16),'YYYY-MM-DD HH24:MI:SS') timestamp, do.last_ddl_time, do.temporary, do.generated, do.secondary, do.namespace, do.edition_name, do.sharing, do.editionable, do.oracle_maintained, do.object_id, do.data_object_id &ddl_column from dba_objects do where 1=1 order by do.owner, do.object_type, do.object_name Added optional DDL column using dbms_metadata.get_ddl for supported object types Y US DBA Objects All database objects Enginatics &ddl_column 1=1 1 10 1=1 lower(do.object_name) like lower(:object_name) LOV custom Y select do.object_name value, do.object_type description from dba_objects do where (:$flex$.object_name_like is null or lower(do.object_name) like lower(:$flex$.object_name_like)) and (:$flex$.owner is null or xxen_util.contains(:$flex$.owner,do.owner)='Y') and (:$flex$.object_type is null or xxen_util.contains(:$flex$.object_type,do.object_type)='Y') and (:$flex$.status is null or do.status=:$flex$.status) order by do.object_name, do.subobject_name US Object Name like 2 20 1=1 do.owner=:owner LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username US Owner 3 30 1=1 do.object_type=:object_type LOV custom Y select do.object_type value, count(*) description from dba_objects do where (:$flex$.object_name_like is null or lower(do.object_name) like lower(:$flex$.object_name_like)) and (:$flex$.owner is null or xxen_util.contains(:$flex$.owner,do.owner)='Y') and (:$flex$.status is null or do.status=:$flex$.status) group by do.object_type order by do.object_type US Object Type 4 40 1=1 do.status=:status LOV custom Y select 'INVALID' value, null description from dual union all select 'VALID' value, null description from dual US Status 5 50 &ddl_column ,xxen_util.object_ddl(do.object_type,do.object_name,do.owner) ddl LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show DDL :$flex$.object_name_like Object Name like Object Name like :$flex$.object_name_like Object Name like Object Type :$flex$.object_type Object Type Object Name like :$flex$.owner Owner Object Name like :$flex$.owner Owner Object Type :$flex$.status Status Object Name like :$flex$.status Status Object Type