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…
Browsing: sql
![2018836700[1]](https://technology.amis.nl/wp-content/uploads/2015/01/20188367001-351x185@2x.jpg "Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring")
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.…
2 Reaching Milestones – some Analytical SQL-etics
Last week, this weblog hit the 9M post reads mark. Since we started technology.amis.nl/blog in July 2004, it took…
0 Seminar: SOA for Database Professionals (April 3rd, The Netherlands)
On Friday April 3rd, I will be presenting a seminar titled “SOA for Database Professionals” – in De Meern, The…
3 Tag Cloud analysis in SQL and PL/SQL – Using Collections, Table Operator, Multiset and Collect operator
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database…
2 Oracle Database Cross Session Data Cache – Introducing the Globally Accessible Database Context
An Application Context in the Oracle Database is a name in-memory collection of key-value pairs. Applications can store values in…
1 Extending the SQL Developer functionality in JDeveloper 11g
One thing that always draws me in tools, libraries and frameworks: what are the hooks, the backdoors, the extension points,…
11 ADF 11g – TreeTable with sub totals – how the SQL query can make life easier for the View developer
The ADF 11g Tree Table component can be used for the compact presentation of fairly complex data sets. It allows…
3 Dynamic and Conditional grouping in SQL queries – for flexible results from single query (oh and a useful case for the CUBE operator)
My challenge of the day: a query that returns aggregate values. And that can be manipulated dynamically to sometimes…
1 Simple Event Processing – Using SQL with Analytical Functions to detect traffic patterns
One of the intriguing subjects at last weeks Oracle Open World conference for me was Complex Event Processing. The ability…
2 OOW Presentation: Optimal Use of Oracle Database 10g and Oracle Database 11g for Modern Application Development
I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database,…
0 DBA 2.0 – how options are really not optional or: "the infinite database"
After Web 2.0, Enterprise 2.0 and Wife 2.0, Oracle introduces the term DBA 2.0. It seems to refer to the…
2 Analyzing Match Scores in ‘fuzzy searches’ – explaining the shades of gray in a non-binary world
In a previous article – Not all has to be black and white in SQL Queries – , I discuss…
0 Not all has to be black and white in SQL Queries: returning match scores instead of only perfect fits
Recently I sat in on a very interesting presentation on an advanced search and matching engine called Elise. The power…
1 Juggling with SQL Types in SQL and PL/SQL – fading borders between Collection and Table
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and…
6 PL/SQL Table-to-Java Bean (and Data to Java Bean Manager) generator – useful for data driven demos without database
The other day, I sat preparing for a demonstration of a data driven Java Web application. I preferred to be…