Oracle Java version - determining which jvm version is used on Oracle database

If You need to find out which java/jdk version in installed along Your Oracle server You can create function and than retrieve java version direcly from JDK. First create function...

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';

.. and then get the version

SELECT get_java_property('java.version') FROM dual;

If You cannot create such function, general rule is that in default installation: Oracle 9 uses JDK 1.3, Oracle 10 uses JDK 1.4.