sql - Page 4 of 6 - AMIS Oracle and Java Blog

Browsing: sql

Database

October 3, 2011 0 OOW 2011 – What's New, Improved and Coming in Oracle Application Development

Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history…

AMIS

September 22, 2011 0 Data Integriteit anno 2011 – Hands-on met Toon Koppelaars en RuleGen 3.0 bij AMIS op dinsdag 27 september

datum: dinsdag 27 september; 16.30 uur locatie: AMIS, Edisonbaan 15, Nieuwegein sprekers: Toon Koppelaars en Lucas Jellema Het belang van…

July 25, 2011 2 Update day to second interval column in selection from time gaps table by parsing strings containing time differences using REGEXP_SUBSTR

An apparently trivial challenge that still took me bit longer than expected. What is the situation: I have a table…

July 6, 2011 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…

July 3, 2011 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…

Java

June 22, 2011 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…

AMIS

April 11, 2011 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.…

April 9, 2011 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…

Data Warehousing & BI

February 6, 2011 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…

December 25, 2010 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.…

December 24, 2010 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…

December 22, 2010 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…

December 20, 2010 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…

Data Warehousing & BI

September 21, 2010 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…

January 11, 2010 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…

November 14, 2009 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…

October 20, 2009 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…

October 13, 2009 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…

Data Warehousing & BI

September 29, 2009 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…

Data Warehousing & BI

September 15, 2009 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…

Previous 1 2 3 4 5 6 Next