14/11/2009 - 8:02 am
Tags: 11gr2, analytical function, connect by, hierarchy, isleaf, lead, recursive subquery, sql
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 3 comments
On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive Suquery Factoring. Instead of using CONNECT BY and its close associates such as START WITH, PRIOR, LEVEL and more exotic comrades like SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT and NOCYCLE this release gave us a new, less proprietary and [...]
23/10/2009 - 7:12 am
Tags: 11gr2, Database, FMW 11g, fusion, hardware, Java, middleware, OOW 2009, Oracle, soa, sun
Posted in ADF & JHeadstart, Database, Devel. + PL/SQL tools, General, Java, JEE, OAS and WebLogic Server, Oracle, SOA & Oracle Fusion Middleware | 2 comments
Vorige week was in San Francisco het hoogtepunt van het Oracle jaar: Oracle Open World 2009, de grootste IT conferentie ter wereld. Tijdens deze conferentie ontvouwde Oracle haar strategie en visie voor de komende periode, lieten product managers de nabije toekomst zien van bestaande en nieuwe producten, deelden honderden specialisten hun ervaringen en toonden leveranciers [...]
Next month, I will visit Australia and Singapore to present on SOA and the Oracle SOA Suite – to Oracle database developers. In this one-day-long seminar, I introduce the key concepts and objectives of SOA (Service Oriented Architecture) as well as the Oracle SOA Suite 11g to an audience of database professionals. Whether you are a DBA [...]
13/10/2009 - 1:17 pm
Tags: 11gr2, Database, ebr, edition based redefinition, Oracle, plsql, universe, upgrade, versioning
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 3 comments
Today I presented on what is possibly the hottest story on the Oracle Database 11gR2 release: Edition Based Redefinition (EBR). EBR allows us to add a whole new dimension to the database – the Edition (that complements the existing dimensions of schema and object type). Every database object (well, almost every database object – not [...]
11/10/2009 - 1:20 pm
Tags: BPEL, Database, database adapter, decouple, esb, mediator, process, soa, soa suite 11g
Posted in Database, Databases, Devel. + PL/SQL tools, General, J(2)EE/Java, Oracle, SOA & Oracle Fusion Middleware | No comments
The Oracle Open World 2009 conference is almost underway. On Monday 12th October I will do two presentations, and I am done preparing the first one of them (the one that has actually sold one – probably scheduled in a small room).This presentation is one in which I introduce the key concepts and objectives of [...]
24/9/2009 - 6:37 am
Tags: 11gr2, availability, Database, ebr, edition based redefinition, editions, planned downtime, release, versions
Posted in Database, Databases, General, J(2)EE/Java, Oracle | No comments
One of the most spectacular new facilities in Release 2 of the Oracle 11g Database is called Edition Based Redefinition – not a name perhaps that suggests any spectacle. EBR (Edition Based Redefinition) is a mechanism that allows on line application upgrade with no planned downtime. In short, the new release is built up in [...]
You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle RDBMS, in the 9iR2 release I believe (or at least that is when they made their way into the Standard Edition). These values are used to find the first respectively last value in a window [...]
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this latest release. These articles are the fruit of several months of studying this new release and projecting which new features and changes would be the most [...]
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this latest release. These articles are the fruit of several months of studying this new release and projecting which new features and changes would be the most [...]
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard. This has never been absolutely true – ANSI SQL was different from Oracle SQL. In some respects the differences can be traced back to lack of functional richness in the standard. However, in certain areas, Oracle [...]
