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


Tips & Tricks


Interesting PL/SQL and Apex links

Written by Richard Weug on Thursday, 05 April 2012 10:10. Posted in Tips and Tricks

Here's a bunch of interesting stuff related to PL/SQL and Apex that I've come across lately, I'm posting it both as a reminder to myself, and to help spread the word:


Saving Master Before Viewing Detail

Written by Richard Weug on Monday, 16 April 2012 10:03. Posted in Tips and Tricks

Master Detail forms are an excellent way to manage a one to many relationship between tables. When using the declarative master detail form, clicking the edit link for a detail record does not save any changes that have been made to the master record. That is because clicking the edit link does not submit the page. A slight modification to the edit link can easily provide that feature. This is also useful for anytime you want to save data and then navigate to another page based on an ID.


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:


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.


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.