check一张表被哪些对象使用

/*check一张表被哪些对象使用*/

SELECT OBJECT_ID
         FROM PUBLIC_DEPENDENCY
       CONNECT BY PRIOR OBJECT_ID = REFERENCED_OBJECT_ID
        START WITH REFERENCED_OBJECT_ID =
                   (SELECT OBJECT_ID
                      FROM SYS.DBA_OBJECTS
                     WHERE OWNER = '%'
                       AND OBJECT_NAME = '%'
                       AND OBJECT_TYPE = '%')