Tuesday, May 23rd, 2006
From the Oracle Technology Network today, there’s this new tutorial aiming to help you create a very handy bit of code combining Oracle’s simple tree-based fetching and Ajax’s flexibility to create an “Ajax Memory Tree”.
In this article, you will learn how to build an Ajax-based memory tree in Oracle Application Express (formerly HTML DB), based on any table that contains hierarchical data. I have added the word “memory” to the name here as, unlike with Carl’s example, this tree will “remember” which nodes are expanded, contracted, and selected across page views. There is also a search function that will locate any node in the tree and expand it accordinglyâ€”something that is not possible with the tree component supplied with Application Express. As the tree makes use of Ajax to fetch nodes as they are expanded, it can easily scale to support a table with thousands or more rows.
They walk you through they steps you’ll need to get the tables all set up and working, as well as installing the needed package to grab the tree data. You’ll need access to an Oracle Application Express workspace to follow along, so if you dont have one, you can apply for one here.
Posted by Chris Cornutt at 6:30 am