oracle查询存储过程里面涉及的表有哪些

<code class="sql">SELECT
    *
FROM
    ALL_OBJECT_TABLES
WHERE
    OBJECT_NAME IN (
        SELECT
            OBJECT_NAME
        FROM
            ALL_OBJECTS
        WHERE
            OBJECT_TYPE = \'PROCEDURE\'
            AND SCHEMA_NAME = \'YOUR_SCHEMA_NAME\'
    )
    AND TABLE_NAME NOT LIKE \'%$%\'
    AND TEMPORARY = \'N\'
ORDER BY
    OBJECT_NAME,
    TABLE_NAME;