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




Create a custom download link

Written by Richard Weug on Monday, 07 May 2012 09:43. Posted in Tips and Tricks

The default method of downloading an Interactive Report is clicking on the Action button, then the Download button and then selecting the desired format.
For the CSV report download format:


Command line backups in Apex

Written by Richard Weug on Thursday, 03 May 2012 09:54. Posted in Tips and Tricks

One thing developers like to do is keep local backup copies of their development work. Sometimes they'll copy files and suffix them with .bak or they'll store them in a version control repository. With APEX you don't copy a file to back it up. Either you have to copy the application (within the workspace) or export the application and save it locally. For one-off backups this can be ok, but as you develop with more and more applications in larger environments it can be tedious work and will slow down your development time.


Redirect to specific page after login Apex Workspace

Written by Richard Weug on Wednesday, 02 May 2012 09:57. Posted in Tips and Tricks

There is a easy way to set up your APEX workspace login URL so that you reach a special page inside your application builder.
The following URL example will let you jump automatically to the SQL Commands interface:


Oracle APEX column with %

Written by Richard Weug on Tuesday, 01 May 2012 09:47. Posted in Tips and Tricks

Or,.. how to format the way an report columns looks,..

If you want to beautify your number column inside an APEX report with a percent-sign then most of you would do like this:
select column_name || '%' as column_name
from my_table


Outlook and Apex

Written by Richard Weug on Tuesday, 01 May 2012 07:51. Posted in Tips and Tricks

You are probably familiar with sending email using PL/SQL; there's the UTL_SMTP package, the APEX_MAIL package, and various other utilities that do this.
But what about reading email using PL/SQL? You need to investigate the POP and IMAP protocols.