Tag: sql

Recently I sat in on a very interesting presentation on an advanced search and matching engine called Elise. The power of this engine lies in the fact that it …

While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular …

The other day, I sat preparing for a demonstration of a data driven Java Web application. I preferred to be able to present the demo without actually having to …

A nice little trick on Oracle 11G is using XMLQuery as an eval function: SQL>l   1  select substr( sys_connect_by_path( level, '*' ), 2 ) || ' = ' …

Solving a Suduku with one SQL-statement, is that possible? A lot of people won’t believe it, but yes, it can be done.

Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …

The Oracle 10g Database release saw an extension of the MERGE statement with a DELETE clause. That by the way makes MERGE the only statement that can fire all …

Title: Mastering Oracle SQL, 2nd Edition Authors: Sanjay Mishra, Alan Beaulieu ISBN:0-596-00632-2 Publication Date: June 2004 More info can be found at website of O’reilly. There’s also a sample …