All posts in 'Oracle'

Modify memory settings of the Oracle Aurora JVM


Use the following class to view and modify the settings of the embedded JVM inside an Oracle database. The class has been tested on 10g and 11g, memory settings and information are in Megabyte. SET DEFINE OFF CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED “MemoryStatistics” AS import oracle.aurora.vm.OracleRuntime; public class MemoryStatistics { public final […]

Read the complete article »

Pretty print XML data within Oracle Databases


Just a short post without further explanation. Pretty printing xml in Oracle 10g and 11g differences quite a bit: 10g: SELECT XMLTYPE('<html><body><p>Hallo, Welt.</p></body></html>’).EXTRACT(’/’) FROM dual; 11g: SELECT XMLSERIALIZE(Document XMLTYPE('<html><body><p>Hallo, Welt.</p></body></html>’) AS CLOB INDENT SIZE = 2) FROM dual;

Read the complete article »

Java implementation of Excels statistical functions NORMINV


I was recently in need of a java implementation of the inverted normal distribution function, named “NORMINV” in Excel 2003 and later: NORMINV. I only found a JavaScript implementation in kmpm’s repository norminv.js. It has quite a history, coming over C# from C++. I have the impression nobody wants to deal with the mathematics 😉 […]

Read the complete article »

How to retrieve tables of custom object types with JDBC


The following is not only a personal reminder for me but also a first try to answer some questions on Stack Overflow… You can create custom object types in an Oracle database like so: CREATE TYPE t_demo_object AS OBJECT ( some_number NUMBER, some_string varchar2(32) ) / Those types can have member functions, custom constructors and […]

Read the complete article »

Oracle, JBDC, CallableStatements and named parameters


Update: Please take a note of comment #5 by DSurber. He works for Oracle and sheds some light on named parameters. In short: The names of the parameter do not refer to named placeholders in statement (like in JPA for example) but to PL/SQL named parameters!. Thank you very much. You might have wondered what […]

Read the complete article »