Tuesday, May 23rd, 2006

Building an Ajax Memory Tree with Oracle

Category: JavaScript, Programming

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.

Once the main part of the application is complete, they throw in some Javascript to help with changing the state. It’s not as flexible as if it had been done with just normal SQL, HTML, and Javascript (with some backend logic thrown in), but it’s still an interesting example.

Posted by Chris Cornutt at 6:30 am
1 Comment

3.4 rating from 21 votes

1 Comment »

Comments feed TrackBack URI

Interesting Finds: May 23, 2006 AM edition

Trackback by Jason Haley — May 23, 2006

Leave a comment

You must be logged in to post a comment.