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


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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Blog at

%d bloggers like this: