Oracle SQL – Finding free adjacent seats in an airplane, using Subquery Factoring, Analytical Functions (LISTAGG and LEAD), Outer Join, PIVOT and good old INSTR

Lucas Jellema 1

Using Oracle SQL to resolve meaningful and slightly less serious challenges is one of my favorite (semi-)professional pastimes. In the last two weeks, I have been presenting on various topics including Oracle SQL to audiences in six cities all across India as part of the OTN Yathra 2013. These presentations […]

How Oracle Database uses internal locks to make statement level constraint validation robust at the transaction level

Lucas Jellema

Data Constraints are essential in protecting the integrity of the data in any relational database. The Oracle Database provides four types of declarative constraints that help implement various types of data rules. These are: Primary Key, Unique Key, Foreign Key and Check Constraint. Although these constraints can be configured to […]

OOW 2012: The yearly AMIS Review from Oracle Open World and JavaOne – slides available

Lucas Jellema

Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012’ session with an overview of news, trends, announcements, special finds and interesting rumors . This session was ‘sold out’ (even though it was free). For […]

Kom kennismaken met AMIS en doe mee met uitdagende projecten

Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten.  Bij ons krijg je de ruimte om […]

Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML

Betty van Dongen

On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem I ran into was the character encoding of the XMLElement function, which eventually was worked around with UPDATEXML. In this blog […]

Review of Oracle Service Bus 11g Development Cookbook (Packt Publishing) by Edwin Biemond, Guido Schmutz, Eric Elzinga et. al.

Lucas Jellema 3

Recently I gained access to an electronic copy of the just released Oracle Service Bus 11g Development Cookbook, written by five authors – all experts on OSB and three personal acquaintances of mine. I was very interested in learning about the final result after hearing many intermediate comments during the […]

Powering the Cloud with Oracle WebLogic

Lucas Jellema

I am presenting later today on the Oracle Fusion Middleware Forum (Spoorwegmuseum, Utrecht). The topic of today’s presentation is cloud computing – especially Platform as a Service – and how WebLogic provides the Platform in the cloud. My presentation can be seen on SlideShare: And downloaded here: https://technology.amis.nl/blog/articles/articles-written-in-2011.

Automatic testing Oracle Service Bus using Jenkins, maven and SoapUI

Robbrecht van Amerongen

A lot of current projects are implementing some sort of service based architecture. Testing in this architecture becomes more complex. When implementing an OSB project with Scrum you test-automation is imperative. Scrum will require more frequent testing of your system. This is only feasible (in time and money) when you […]

AMIS Query – Verslag van Oracle Open World 2009 – dinsdag 27 oktober (uitnodiging)

Lucas Jellema 2

Vorige week was in San Francisco het hoogtepunt van het Oracle jaar: Oracle Open World 2009, de grootste IT conferentie ter wereld. Tijdens deze conferentie ontvouwde Oracle haar strategie en visie voor de komende periode, lieten product managers de nabije toekomst zien van bestaande en nieuwe producten, deelden honderden specialisten […]

The AMIS team reports from Oracle Open World – big and small announcements, guidance and tips

Lucas Jellema 2

Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle Applications (AIA) and Development technology, we presented the highlights from close to 1900 sessions – no small feat. And utterly incomplete […]

Oracle & JDBC – Passing a ‘table of custom object type’ to a stored procedure – implementing efficient single round trip data exchange (part two of an ADF application on a PL/SQL API)

Lucas Jellema 3

One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a heterogeneous data set, for example a data set with master and details records, custom type based objects can provide a powerful […]

Map Adventures with Google, Oracle and Spring

In summer 2000 I started in the Field Service development team of Oracle’s eBusiness Suite (http://www.oracle.com/applications/service/srvonl_cont.html). The web form Dispatch Center contains four Java applets. One of them is a map. This map displays the location of the customers and the current position of the field service engineers who synchronize […]