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

 

PL/SQL stuff

Print
16
Apr

Logger 2.0.0 Alpha

Written by Richard Weug on Tuesday, 16 April 2013 12:58. Posted in PL/SQL

Logger is a PL/SQL logging and debugging framework. It's used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0.

I contacted Tyler a few months ago about the possibility of working together to upgrade Logger and expand on its capabilities. Since then we've been busy working on Logger on our spare time (which isn't much these days). That being said, I'm pleased to announce that Logger 2.0.0.a01 (Alpha) is now available to download!

Besides some underlying changes, such as moving to GitHub and a new build script, the following things were added to Logger:

Print
16
Apr

PL/SQL Email Client package: version 1.0 is available

Written by Richard Weug on Tuesday, 16 April 2013 12:55. Posted in PL/SQL

PL/SQL Email Client package: version 1.0 is available
Nach einer sehr langen Zeit (um genau zu sein: nach 2 1/2 Jahren), konnte ich endlich eine neue Version meines Projektes PL/SQL Email Client online stellen. Neu in Version 1.0 sind

Print
11
Jun

Select into statements..

Written by Richard Weug on Monday, 11 June 2012 08:50. Posted in PL/SQL

One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table into local variables. The problem is that the data may or may not exist (i.e. return 0..1 rows). They're several ways to write this code, some taking longer than others which is the pain point for developers.

Print
04
Jun

NTH Value windowing

Written by Richard Weug on Monday, 04 June 2012 09:05. Posted in PL/SQL

In my previous post which highlighted some analytic functions, I mentioned that the windowing clause must be explicitly defined when using the NTH_VALUE function. To recap, here's the example I used for NTH_VALUE which lists the 2nd highest salary for each department:

Print
29
May

Interesting Analytical Functions

Written by Richard Weug on Tuesday, 29 May 2012 09:44. Posted in PL/SQL

I had to write some reports for a personal application of mine last night and needed to expand beyond my usual set of analytic functions that I normally use. I thought it would be a good idea to do a quick blog post on these analytic functions.