如果需要显示它或者其他东西,可以查看DBMS_JAVA.EXPORT_SOURCE,它将源代码放在可以操作的PL / sql结构中.

通常,如果您只想列出所有与Java相关的存储对象,则可以执行以下操作：

SELECT
  object_name,object_type,status,timestamp
FROM 
  user_objects
WHERE 
  (object_name NOT LIKE 'SYS_%' AND 
   object_name NOT LIKE 'CREATE$%' AND 
   object_name NOT LIKE 'JAVA$%' AND 
   object_name NOT LIKE 'LOADLOB%') AND
  object_type LIKE 'JAVA %'
ORDER BY
  object_type,object_name;