APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn




Manage your LOVs in PL/SQL

Written by Richard Weug on Monday, 04 February 2013 14:16. Posted in Tips and Tricks

Oracle APEX offers an easy to use, yet effective way to control the list of values (LOVs) within your application. This module, which can be found under shared components, enables you to create two different types of LOVs: static and dynamic. Reusability and maintainability are the key principles here: “create once, use many times“. However, I always feel like there is one single shortcoming every time I work intensively with LOVs: The inability to parameterize.


Getting and setting Apex page item values using $v(), $s(), $v2()

Written by Richard Weug on Tuesday, 22 January 2013 14:43. Posted in Tips and Tricks

The Apex JavaScript API has some very convenient functions to access the values of page items.For example, if you wante to access the contents of a text field with JavaScript, would would need to reference it something like this:


Refreshing a tabular form

Written by Richard Weug on Thursday, 03 January 2013 14:14. Posted in Tips and Tricks

Today I encountered some difficulties refreshing a tabular form without submitting the entire page. The data displayed in my tabular form depends on the value of a select list (nothing more than a parent-child relation). If you don’t know where I am talking about, please check out following example.


PDF Creation with direct print dialog

Written by Richard Weug on Thursday, 13 September 2012 09:10. Posted in Tips and Tricks

This solution is based on the usage of Jasper Reports to create PDF reports inside APEX.

You may had the requirement to create a PDF document with a direct print dialog but there should be no download pop-up dialog or an in-line view appear where the end user explicitly needed to click on the print button. Seems to be a simple problem: Print dialog should immediately appear after PDF creation.

Actualy there is a quite easy workaround available:
Just add this new property under the properties section (for you document) in the iReport builder settings.

/* Property name */
/* Property value */
this.print({bUI: true,bSilent: true,bShrinkToFit: false});


Show table comments in SQL developer

Written by Richard Weug on Monday, 11 June 2012 08:52. Posted in Installation

My default development client is the Oracle SQL Developer. If I compare it with TOAD it is slim, free to use and includes a table modeling area.
One thing I don't like is the ability to see table comments. To find this information you need to click on the table inside the table view ("Connections" > #MY_CON2# > Tables), then on tab: "Details", scroll to column "Comments" and finally double click on the comment field to see all details.