oracle aide

August 27, 2007

Application Express. A Movable Feast.

Filed under: Apex — oracleaide @ 1:45 am

A deserved praise from a modest weekend code warrior:

  • Oracle Apex Portal is a development tool that is always online.
  • It is accessible from anything with a browser.
  • It is platform independent.
  • It is free from security hassles of VPN and Remote Desktop.
  • It is free.
  • I do not feel like I work overtime on my weekend when I use for prototyping.
    It is more like playing games online.


    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.

    August 17, 2007

    Low cost pagination query

    Filed under: Apex — oracleaide @ 9:01 pm

    Here is a little entertaining project I dealt with lately – to write a generic table browser using Application Express.

    Since the browser is generic, i.e. SELECT statement is not known until run time – I cannot use most of the RAD gadgets of the IDE and many useful APEX features, like the built-in pagination.

    The solution is simple:

  • use Dynamic SQL,
  • select one page of rows at a time,
  • convert it into XML,
  • run through a style sheet using DBMS_XMLQuery and
  • get a complete HTML page at the end.
  • Handmade pagination is trivial – unless you select from a very large table.
    Here is an example of SQL I came up with:

    Create a free website or blog at