SELECT owner,object_name
FROM dba_objects 
WHERE object_type = 'PROCEDURE'

DBA_SOURCE视图将列出相关过程的源代码行：

SELECT line,text
FROM dba_source
WHERE owner = ?
  AND name = ?
  AND type = 'PROCEDURE'
ORDER BY line

注意：根据您的权限,您可能无法查询DBA_OBJECTS和DBA_SOURCE视图.在这种情况下,可以使用ALL_OBJECTS和ALL_SOURCE. DBA_视图包含数据库中的所有对象,而ALL_视图仅包含您可以访问的对象.