0 RuleGen 3.0 – the latest, leanest and most robust solution for complex data constraints in an Oracle Database
No matter how complex the enterprise and application architectures become, no matter the number of tiers, services, devices and user…
Browsing: sql
0 Using SQL UNPIVOT to prepare data for dynamic ADF Faces User Interfaces
The UNPIVOT operator was introduced in Oracle Database 11g – see for example: https://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is…
0 Using the ADF DVT Radar Graph for comparing series – further analyzing ODTUG Kaleidoscope 2011 Session Schedule
I have always had a fascination for the Data Visualization capabilities of all the tools and technologies I have worked…
0 How to use an outerjoin to synchronise data
There is often a need to synchronize data from a query. For example reading external data and update the tables.…
3 The Knight's Challenge – Recursive SQL Queries make a move on the Chess board
In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than…
2 Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us…
2 Anti-Search patterns – SQL to look for what is NOT there – Part Two
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there.…
1 Retrieving the values for domains in SQL queries in the Oracle RDBMS – months, days, numbers and custom value sets
It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to…
0 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…
5 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…
0 Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may…
3 ADF 10g Dynamic Columns: Or how to implement an updatable dynamic table
Although it is all about ADF 11g these days there are still some challenges in ADF 10g projects that run…
5 Oracle 11gR2 – alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring (dedicated to Anton)
On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive…
3 SOA & SOA Suite for Oracle Database Professionals – seminars in Perth and Melbourne and Singapore (November 2009)
Next month, I will visit Australia and Singapore to present on SOA and the Oracle SOA Suite – to Oracle database…
45 Oracle RDBMS 11gR2 – Solving a Sudoku using Recursive Subquery Factoring
Oracle Database 11g Release 2 introduces a new feature called Recursive Subquery Factoring. My collegue Lucas sees it as a…
1 Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring
Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive…
0 Oracle Database 11gR2 – New analytical function NTH_VALUE
You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle…
3 Oracle SQL and PL/SQL: juggling with user defined types (ADT) and XMLType – for creating an ADT based XML Service API
Packages in the Oracle Database are a fine construct to use for creating a service API at PL/SQL level -…
5 Oracle RDBMS 11gR2 – LISTAGG – New aggregation operator for creating (comma) delimited strings
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an…
22 Oracle RDBMS 11gR2 – goodbye Connect By or: the end of hierarchical querying as we know it
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard.…