SQL Server Details - Yash-777/oracle-aq-samples GitHub Wiki

Check Java version used in Oracle Database

SELECT dbms_java.get_jdk_version JDK_Version FROM dual;
-- DEV: 1.7.0_301  javax.mail.MessagingException: Remote host closed connection during handshake;
-- INT: 1.6.0_211
-- UAT: 1.6.0_211

select get_java_property('java.version') from dual;
SELECT  dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual;

Viewing Database Version Information

In SQL Developer, click the Reports tab on the left, near the Connections navigator. (If this tab is not visible, click View, then Reports.)

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
"CORE	12.1.0.2.0	Production"
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production