Roels Blog

Developers with an Oracle Forms background might still remember this nice feature: If you click on a row in an Oracle Form "report" then it can be highlighted - either the full row or just a small first item of the row. The main difference with the Oracle Forms "reports" and the APEX Reports is that in Forms a "report" is usually comparable to an APEX Tabular Form. But a similar feature is frequently asked for - especially at customer sites that are transforming from Forms to APEX. With a few lines of code we can make these customers happy .... Let's get started. First of all your query should contain one column (as "Plain Text") that describes the Primary Key - that might even be a concatenated set of columns. Now we have to tell APEX that this is the column that contains our PK. For a Standard Report just add the CSS class "rowlink" to the column (without the quotes) . For an Interactive Report we need to use the HTML Exp...

Recently I was asked by someone from Packt Publishing to review the new book " Oracle APEX 4.2 Reporting " - in exchange for a free e-copy. When I saw the table of contents, I already thought: " This is covering a lot... ". And that turns out to be true - and one of the main points of criticism I have. It starts off with a whole chapter about Installation and Configuration . The title of the chapter doesn't say that, because it's called " Know your horse before you ride it ". Thats one of the other points of criticism: The author is now and then to be trying to be funny and entertaining (in his own way). Another example: after a paragraph about installing the APEX Listener he writes: " APEX now has ears ". And there are much more examples - to me it's annoying and distracting. But the major part of that chapter is very well covered by the installation documents that come with the different products. Another remarkable note is ...