Skip to main content


Showing posts from July, 2008

The future of SQL Developer - the end of Designer?

Last month Oracle released a statement of direction for SQL Developer (here it is). Apart from the enhanced testing capabilities the most important feature will be the support of graphical logical and physical data modeling - just like you normally would do using Oracle Designer - using the acquired CDW4ALL extension. This modeling can be used offline (file-based, using XML files) or repository based. So Oracle seems to be moving (some) essential Designer features towards SQL Developer, therefore reducing the need for Designer - which is obviously in 'maintenance mode' (no new features added).
One thing that worries me a little is that this "functionality is delivered as an optional extension". That sounds a little like $$$...., but I'm not sure about that!

11th out of 233 OOW sessions in the mix

Out of the suggested 233 sessions for Oracle Open World 2008 on The Mix my suggestion on "(Re)developing a logistic application in the real world" ended on a joint 11th place. It is (officially) unknown how many sessions will make it to OOW, but there are rumors that it will be somewhere between 25 and 35.... So I expect to get an invitation from Oracle soon!
I'm really looking forward to present in San Fransisco!

Drag & Drop feature in APEX - The details

As I promised in an earlier post on Drag & Drop in APEX I would reveal the more technical ins and outs of this cool feature. But instead of blogging about it myself, I hereby refer to the blog of my colleague Rutger. He did a great job in explaining how we achieved this - with a link to an application on, so you can try it out yourself - , so please take a look there!

Reusable Module Components in APEX

When building a serious application you often need to repeat certain regions in a couple of pages, for instance customer or order information. In APEX you can ofcourse copy a region to another page, but that enhances your maintenance effort when changes are needed on this copied region. Another solution is to group all the pages that share this region in one application and define the region on the famous Page 0. But maybe there is a more elegant way to solve this....

As an example I use the 'My Favorite Tasks' region I described in the previous post. First we set the page alias to 'MYFAV', to circumvent a static reference to a page number. In the region header of 'My Favorite Tasks' we set a HTML tag '<snap>' and '</snap>' in the footer (this <snap> is just an example, it can be anything, as long as it isn't a regular HTML tag). Now define a new HTML region on the page where you need to 'reference' this 'My Fav…

Dynamic 'My Favorites' Links in your APEX Application

For a (even more) Web 2.0 like look-and-feel in your APEX application you can define a dynamic region 'My Favorite Tasks', that shows links to the pages you visit most frequently.
For these favorites we can query the APEX repository. Follow these steps to get this thing working:

Enable logging on Application Level. Enabling the logging will result in records in the view apex_workspace_activity_log.Create a Report Page with a region based on a SQL Query.Enter the query to show the links for the three most visited pages:select htf.anchor( 'f?p='||:APP_ID||':'||page_id||':'||:APP_SESSION
, page_name ) Task
select page_name
, page_id
, count(*)
from apex_workspace_activity_log
where application_id = :APP_ID
and apex_user = :APP_USER
and page_id <> :APP_PAGE_ID
group by page_name, page_id
order by 3 desc
where rownum <= 3 In a next post I will show how you can embed this report page in any other page in your application.