How to check the java version of an Oracle Database

Create a function in the DB to retrive the java properties:

[sql]CREATE OR REPLACE FUNCTION get_java_property(prop IN VARCHAR2)
RETURN VARCHAR2 IS
LANGUAGE JAVA name ‘java.lang.System.getProperty(java.lang.String) return java.lang.String’;[/sql]

Then, run the following command to output the Java version:

[sql]SELECT get_java_property(‘java.version’) FROM dual;[/sql]