Oracle中如何查看指定的表被哪些表所引用
SELECT TABLE_NAME ?FROM dba_CONSTRAINTS WHERE R_CONSTRAINT_NAME IN(
select CONSTRAINT_NAME from dba_CONSTRAINTS T?
where table_name='RESOURCE_TYPE' AND T.owner='ITSM_LS1'
)
发布时间: 2012-09-04 14:19:30 作者: rapoo
Oracle中如何查看指定的表被哪些表所引用
SELECT TABLE_NAME ?FROM dba_CONSTRAINTS WHERE R_CONSTRAINT_NAME IN(
select CONSTRAINT_NAME from dba_CONSTRAINTS T?
where table_name='RESOURCE_TYPE' AND T.owner='ITSM_LS1'
)