In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than…
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us…
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there.…
It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to…
![2018836700[1]](https://i0.wp.com/technology.amis.nl/wp-content/uploads/2015/01/20188367001.jpg?resize=351%2C185&ssl=1 "Extreme Decoupling in SQL – Select and DML against a table that is not a table at all")
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently…
![javacode-908579[1]](https://i1.wp.com/technology.amis.nl/wp-content/uploads/2014/07/javacode-9085791.jpeg?resize=351%2C185&ssl=1 "Anti-Search patterns – SQL to look for what is NOT there – Part One")
Usually in SQL queries, you will try to retrieve information from a database by reading specific records from the relevant…
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may…
Although it is all about ADF 11g these days there are still some challenges in ADF 10g projects that run…
On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive…
Next month, I will visit Australia and Singapore to present on SOA and the Oracle SOA Suite – to Oracle database…
Oracle Database 11g Release 2 introduces a new feature called Recursive Subquery Factoring. My collegue Lucas sees it as a…
Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive…
You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle…
Packages in the Oracle Database are a fine construct to use for creating a service API at PL/SQL level -…
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an…
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard.…
Last week, this weblog hit the 9M post reads mark. Since we started technology.amis.nl/blog in July 2004, it took…
On Friday April 3rd, I will be presenting a seminar titled “SOA for Database Professionals” – in De Meern, The…
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database…
An Application Context in the Oracle Database is a name in-memory collection of key-value pairs. Applications can store values in…
