Oracle

Should be similar to this: http://blogs.oracle.com/shay/2009/12/displaying_hierarchical_data_f.html

Oracle Press Release Oracle Unveils Oracle® Business Intelligence 11g New Release Integrates Relational and OLAP Analysis and Delivers New Capabilities in Enterprise Reporting, Scorecards, Visualization, and Collaboration LONDON – April 7, 2010 News Facts Oracle today announced Oracle® Business Intelligence 11g, the most complete, integrated and scalable suite of Business Intelligence products for customers to [...]

According to the doc The subquery_factoring_clause now supports recursive subquery factoring (recursive WITH), which lets you query hierarchical data. This feature is more powerful than CONNECT BY in that it provides depth-first search and breadth-first search, and supports multiple recursive branches. A new search_clause and cycle_clause let you specify an ordering for the rows and [...]

Not the next installment quite yet, just an update from what I knew yesterday. Right after I posted the Real Excel Templates I. Mike from the PM team got in touch to say he and Shirley had just had a meeting with a customer about the Excel Templates and all the fab features. He included [...]

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 [...]

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’ [...]

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

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 [...]

Hierarchical data displays with Oracle ADF Link to the original site

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 [...] Link [...]