Daily Roundup of News, Tips and Tricks for 2010-02-06

Problems Hit New Oracle Support Site Again – PCWorld
Problems once again wracked Oracle's new My Oracle Support portal this week, with some users reporting difficulties accessing the site.

Querying Hierarchical Data in Oracle Database 11g Release 2
Recursive database processing, also called the bill of materials or parts explosion problem, is applicable to many application domains including [...]

Numbers to Words Update

Been a while I know, crazy busy, which is not a bad thing but the blog suffers. Last week was spent embedded in all things 11g BI including the new version of Publisher. There are some very cool and more importantly useful, features coming. My favorite is the new data builder tool; no more ‘notepad’ [...]

Displaying Hierarchical Data from a Web Service in JSF with ADF

Someone asked on OTN if we can use data coming from a Web service to populate a hierarchical tree in a JSF page.
The answer is yes – and with the Web service data control this is actually very simple in JDeveloper 11g.
Here is a quick demo:

Link to the original site

JDev 11gR1 – af:tree mashup – using hierarchical tables and drag n drop

This blog post demonstrates creating an ADF Faces RC af:tree component that sources its data from a hierarchical database table, and supports drag n drop of the nodes.
Both these topics have been discussed and demonstrated by other excellent bloggers, the core of this post is to bring both concepts together, with my usual own proof [...]

Targets, Accessors, and Trees

Hierarchical data displays with Oracle ADF
Link to the original site

Hierarchical Query to Unordered List

I’m working on a project which involves hierarchical data that I want to output as an unordered list in HTML. I want to do this in a single SQL statement without resorting to PL/SQL loops. This is partially to post my solution, as well as to solicit ideas from anyone else who has [...]

July/August Frameworks Column Now Available

The July/August 2009 issue of Oracle Magazine is now live, and along with it the latest installment of my Developer Frameworks column:

Targets, Accessors, and TreesHierarchical data displays are simple with Oracle Application Development Framework.
Enjoy.
Link to the original site

Frameworks: Targets, Accessors, and Trees

Hierarchical data displays are simple with Oracle Application
Development Framework.
Link to the original site