Oracle中存储的Java类在哪里？ [英] Where are java classes stored in Oracle?

问题描述

oracle数据库中存储的已加载java类的java字节码在哪里？具体来说，是否有一个视图或表可以用来获取Oracle中java类模式对象的原始字节？

Where is the java bytecode for loaded java classes stored within an oracle database? Specifically, is there a view or table I can use to obtain the raw bytes for java class schema objects within Oracle?

推荐答案

如果您已经使用CREATE JAVA SOURCE命令将Java Source加载到Oracle数据库中，然后您可以转到数据字典视图USER_SOURCE并找到您的Java源代码。

If you have used CREATE JAVA SOURCE command to load the Java Source into the Oracle database then you can go to the data dictionary view USER_SOURCE and find your Java Source.

如果您需要要显示它或者某个东西，你可以查看DBMS_JAVA.EXPORT_SOURCE，它将源代码放在你可以操作的PL / SQL结构中。

If you need to display it or something, you can check out DBMS_JAVA.EXPORT_SOURCE which puts the source code in PL/SQL structures that you can manipulate.

一般来说，如果你想要列出所有与Java相关的存储对象，您可以执行以下操作：

Generally, if you want to just list all Java related stored objects you can execute the following:

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;

这篇关于Oracle中存储的Java类在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！