Author: Lucas Jellema
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one …
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by …
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …
One of the brand new specifications in Java EE 7 is JSR-352 Batch Applications for the Java Platform. This specification describes how Java EE containers will allow applications to …
In this article, I show how I have created a simple and fairly meaningless Java EE 7 application that uses a number of smart Java EE features: a stateless …
Last week saw the release of Java EE 7 – the new edition of the Java Enterprise platform. It is a substantial release – which advances the Java Enterprise …
It was fairly difficult to come up with a title for this article that sort of covers the content. To me it is quite clear what this is about …
Last week I was prompted to take a look at the new Oracle ADF Academy that has just published its first lesson: Developing Applications with ADF Mobile. As you …
To be useful, data held and used in information systems has to live up to a number of expectations. The data should be an accurate representation of its source. …
We all know a lot of money is involved with professional sports. One of Europe’s major sports is football (or soccer as some like to call it). A lot …
In a recent article (https://technology.amis.nl/2013/04/02/adf-dvt-using-the-tree-map-visualization-component-to-compare-relative-sizes-and-distributions/) I discussed the ADF DVT Treemap component. This component visualizes data in such a way that comparisons between data values for different records and …
The tree map component is one of those data visualization components that can tell an entire story through a simple picture. But of course that picture is anything but …
One recurring theme in my articles on ADF has been that end users usually do not care about data. They are interested in getting information that helps them answer …
Communication between taskflows and pages, beans and other components in ADF Faces applications is in many cases ideally implemented using contextual events. These events are published from a producer …
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 …
Gantt Charts in ADF are interesting components to visualize data that is organized according to time. The Gantt Charts have a horizontal time axis. In rows along the vertical …
The challenge in this article is a simple one. I have a table with records (duh!) and each record describes the occurrence of a certain payload. In this example …
I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than …
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 …
In various recent articles (such as Drag and Drop in ADF DVT Schedule Gantt) I have discussed the ADF DVT Gantt Chart component. And in these articles I have …
Yesterday the OTN Yathra visited Bangalore. In the local Oracle office, two rooms were reserved for 14 technical sessions by Oracle ACE Directors, ACEs and other specialists from both …
In a recent meeting of the AMIS ADF SIG we organized a speed date with six different DVT components (note: DVT == Data Visualization Tags, the library of rich …
The OTN Yathra 2013 is taking a group of Oracle ACE Directors across all of India. From New Delhi to Chennai and four cities in between, this AIOUG (All …
The challenge I will address in this article is the following: I would like to provide a nice presentation of data aggregated by time period. For example: an overview …
Recently the ADF Special Interest Group at AMIS organized an ADF DVT Speed Date. During this speed date, six ADF specialists from our team presented their favorite Data Visualization …
While working on a Web application that required some page to report data aggregated on several levels of time period – by month, quarter or year – I ran …
On the Oracle Technology Network, architecture section, my article titled “Fanning Out Events on the Oracle SOA Suite 11g Event Delivery Network” has just gone live: This article describes: …
The Oracle ACE directors and Java champions are organizing an evangelist event called ‘OTNYathra 2013’ between 15th & 27th February 2013. The event is sponsored by the Oracle Technology …
Whether you are deciding on the framework to use for your next Java web or mobile project or whether you are contemplating your next career step as a Java …
The ADF framework strongly suggests if not dictates a certain application architecture. Through ADF BC (Business Components) – the predominant business service implementation with ADF – applications will typically …
In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions …
After teaching the Advanced SQL Masterclass recently, one of the attendees confronted me with an interesting challenge for me to solve with all the tools I had been discussing …
I have just completed my first ever presentation on the Expertezed.com network – http://www.expertezed.com/ , a reprise from my session on Oracle OpenWorld 2012. This presentation includes a number …
De titel suggereert niet alleen dat er bij AMIS kennis wordt gedeeld – hetgeen in flinke mate het geval is – maar doet ook vermoeden dat dat seizoensgebonden is. …
Of je nu ‘klassieke’ Oracle applicaties ontwikkelt, met APEX bezig bent, een SOA landschap inricht of een Java/JEE (bijvoorbeeld ADF) applicatie bouwt: het fundament van veel van wat je …
The attraction of APEX has increased tremendously with the recent launch of the Oracle Cloud. APEX already supported departmental development and deployment of business applications with minimal involvement from …
If you are an ADF developer – and The Netherlands are within reach for you – then Friday 21st of December is a day to mark in your diary. …
Not too long ago, one of my customers had the following requirement: a file with invoice-entries has to be processed each night; for all invoice entries for the same …
There is no beauty contest to determine which Fusion Middleware product shone the brightest during Oracle Open World. And it is a matter of taste any way. In this …
![AMIS Masterclass Advanced SQL – scherp je SQL skills in een pittige en praktijkgerichte dag – maandag 10 december]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "AMIS Masterclass Advanced SQL – scherp je SQL skills in een pittige en praktijkgerichte dag – maandag 10 december")