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

Blog at WordPress.com.