34 lines
1.0 KiB
SQL
34 lines
1.0 KiB
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
col dep_owner head OWNER for a16
|
|
col dep_name head DEPENDENT_NAME for a30
|
|
col dep_type head DEPENDENT_TYPE for a12
|
|
col dep_referenced_owner head REF_OWNER for a16
|
|
col dep_referenced_name head REF_NAME for a30
|
|
col dep_referenced_type head REF_TYPE for a12
|
|
col dep_depency_type head HARDSOFT for a8
|
|
|
|
select
|
|
owner dep_owner,
|
|
name dep_name,
|
|
type dep_type,
|
|
referenced_owner dep_referenced_owner,
|
|
referenced_name dep_referenced_name,
|
|
referenced_type dep_referenced_type,
|
|
dependency_type dep_dependency_type
|
|
--
|
|
--from dba_dependencies where owner like '&1' and referenced_owner like '&2'
|
|
--from dba_dependencies where owner like '&1' and name like '&2'
|
|
--
|
|
from
|
|
dba_dependencies
|
|
where
|
|
lower(owner) like lower('&1')
|
|
and lower(name) like lower('&2')
|
|
and lower(referenced_owner) like lower('&3')
|
|
and lower(referenced_name) like lower('&4')
|
|
/
|
|
|
|
|