Skip to content

Daily Archives Wednesday, September 2008

Cube, Rollup, Grouping Sets and Grouping IDs

If you’ve kept up with the various new data warehousing features in Oracle over the past few years, you might have noticed extensions to the GROUP BY clause such as ROLLUP, CUBE, GROUPING SETS and so on. If like me you’ve glanced at these features and mentally noted them as being potentially useful, you might [...]

Posted 10 September 2008 † Mark Rittman § Uncategorized ‡ Comments Off °

Separated at Birth?

While answering comments today, a separated at birth popped into my head for Google Chrome, the HAL 9000.

The Chrome logo is also very reminiscent of eyes the CG Transformers have in last year’s live-action movie. I don’t recall that Skynet had a logo, but I’m sure it would be the type of shiny eye [...]

Posted 10 September 2008 † Jake § Uncategorized ‡ Comments Off °

Utrecht Apex Training - Followup

A few days ago we held our third open European Application Express training days in Utrecht, The Netherlands.
It was my first time in the Netherlands and I loved it, I have to say I thought it was a bit of myth about everyone using bicycles until I saw more bicycles in 20 minutes than I’ve [...]

Posted 10 September 2008 † John Scott § Uncategorized ‡ Comments Off °

JDev 11g ADF BC – New feature “Property Sets”

“Property Sets” are a new addition to ADF Business Components (ADF BC) in JDeveloper 11g. Property Sets are related to the extensible Custom Properties framework definable on EO & VO attributes, as well as at the EO, VO and & AM levels. If you’re not familiar with the power and usage of ADF Business Component extensible Custom Properties look at my previous post I rest my case: Converting ADF BC EO/VO attributes to upper and lower case with custom properties or Avrom Roy-Faderman’s post The Power of Properties.

Property Sets allow us to define a set of Custom Properties, essentially key value pairs, and then apply them to the ADF BC objects, without having to manually create each key value pair manually ourselves.

If we take a rather simplistic example, we could define a new Property Set “Alpha”, with 2 properties “Beta” and “Charlie” as follows:

Then for example, we can select an attribute out of an EO or VO, and change the Property Set value to our new Property Set:

To prove the Custom Properties apply at runtime, without coding, within the Business Components Browser, we can right click on the attribute in question, and you can see a small information box that shows the runtime properties of the field, including the Property Set key value pairs we created.

This is obviously just a small new feature within JDeveloper 11g, but yet again a declarative productivity booster to stop the programmer having to waste time inputing values.

Posted 10 September 2008 † Chris Muir § Uncategorized ‡ Comments Off °

RAC SIG Officers Announced

Thanks to everyone that took the time to vote in the recent RAC SIG elections. We had a very successful election with almost 600 members voting for the 6 open positions. The new board will be installed at Oracle Open World on Monday, September 22nd in Moscone South 306 preceding our RAC SIG Expert Panel [...]

Posted 10 September 2008 † Dan § Uncategorized ‡ Comments Off °