I’m evaluated…

UKOUG 2012 evaluations have arrived - I think I did OK :-).


On a scale from 1 to 6 my scores were:

  • Topic: 5.5
  • Content: 5.5
  • Presentation skills: 4.83
  • Quality of slides: 5
  • Value of presentation: 5.67
I'm quite happy with those scores - particularly that the 6 people that filled out evaluation schemas thought they got a lot of value from the presentation. The skills score is fair, I had expected a bit less as I know I am not world class presenter - but I hope practice makes better :-)

The comments also makes (more...)

Formspider comes to Denmark

For the Danish Oracle User Group (DOUG) I'll be hosting a Formspider event in Copenhagen January 21st 2013. I look forward to seeing Yalim Gerger demonstrate this alternative to APEX or ADF or Forms.

The event will take place in my company's classroom at Banestrøget 17, 2. th., 2630 Tåstrup, which is 2 minutes walk from Høje Tåstrup train station.

Program for the afternoon:
  • 13:30 - 14:30 Introducing Formspider, the Web 2.0 framework for PL/SQL developers
Yalim Gerger, Founder&CEO of Formspider talks about the vision and the benefits of the Formspider Framework.

Thank you, UKOUG 2012

So, I'm about to leave UKOUG 2012. I had a good time and learned quite a bit from the smart people gathered in Birmingham ;-)

Thank you to those attending my presentation on analytic functions - I hope you learned something from it. If you need to take a closer look, both presentation and scripts can be found here.

Birmingham Airport next stop...

Analytic FIFO multiplied – part 3

This is part 3 of a three part posting on analytic FIFO picking of multiple orders. Part 3 shows how to combine the FIFO developed in part 1 with the analytics used for the better route calculation in an earlier blog post.



We use the same tables and same data as part 1, so read part 1 for the setup.

When combining the FIFO for multiple orders with the route calculation, we get this nice piece of sql:


with orderlines as (
select o.ordno
, o.item
, o.qty
, nvl(sum(o.qty) over (
partition by o. (more...)

Analytic FIFO multiplied – part 2

This is part 2 of a three part posting on analytic FIFO picking of multiple orders. Part 2 shows an alternative way of doing the same thing as part 1 did - but this time using recursive subquery factoring in Oracle v. 11.2.



We use the same tables and same data as part 1, so read part 1 for the setup.

And just to recap - here's the picking list developed in part 1:

with orderlines as (
select o.ordno
, o.item
, o.qty
, nvl(sum(o.qty) over (
partition by o.item
order by o. (more...)