oracle aide

August 21, 2007

Generic table browser / editor with Application Express

Filed under: Apex, DBMS_XMLQuery, XSLT, XSU — oracleaide @ 8:21 pm

The Uber Browser demo was published on apex.oracle.com.
The application is long gone (Oracle regularly cleans up demo accounts), but the source code is still available,
It uses the low cost pagination query described in the previous post.

Since the apex.oracle.com site does not hide users schemas from each other – Uber Browser becomes a dangerous tool.

To protect tables of other developers I had to limit it to my own schema and two demo tables.

Under the hood: a good mix of Dynamic SQL with Oracle XML gadgets (DBMS_XMLQuery + XSLT).
Very few moving parts.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: