SELECT * FROM all_objectsWHERE object_type LIKE 'PROCEDURE'AND owner LIKE '%用户%';用户替换成你oracle想查询的用户名即可
