Wednesday, December 14, 2011

I'm a'goin' to speaka at KScope12

Just got confirmed - I've been selected as one of the many speakers at Kaleidoscope. Can't quite believe it, but it's a nice feeling :-) Now I gotta start writing the presentation and create demo scripts. Fun!

Thursday, August 18, 2011

Analytic picking route

In my previous post I showed how to use analytic rolling sums to do FIFO picking of items. But the final picking list of the solution had a weakness - the forklift driver picking the items would have to drive back and start from the beginning of each aisle in the warehouse.

In this post I show how to use analytic ranking to create a better more optimized picking route for our forklift driver to keep him happy :-)

Thursday, July 28, 2011

Analytic FIFO picking

Analytic functions is a subject I can become quite passionate talking about. How anyone can live without using analytics when programming SQL is beyond me :-)

One of my favorite examples is picking items in our warehouse by First-In First-Out (FIFO). (Similar technique has been parallel evolved by Monty Latiolais as presented by Alex Nuijten at KScope11 - great minds think alike :-) I have demoed this at a DOUG meeting in Copenhagen - here I elaborate a bit on that demo-script.


Welcome to my blog (or at least an attempt to blog something about Oracle SQL and PL/SQL :-)

I'm Kim Berg Hansen and I work as Senior Developer at Trivadis Danmark. Since the year 2000 I have programmed quite a lot of Oracle SQL, a good deal of Concorde XAL, some Oracle PL/SQL, and a smattering of all sorts of other programming languages as the various tasks have mandated.

I am OCE (Oracle Certified Expert) on Oracle SQL, and being honored to be an Oracle ACE Director as well.

I am the main author of the SQL quizzes on the Oracle Dev Gym - a website by Steven Feuerstein where you can learn and hone your PL/SQL and SQL skills by taking weekly quizzes.

I have joined the fabulous community of ODTUG and attended the Kaleidoscope (now Kscope) conference since 2010. I've presented on various topics at several Kscopes as well as other conferences.

I plan to go to KScope every year in the future if possible - I can think of no other event as great as that :-) I can recommend going to Kscope, if you can make it. I'll be there for certain.

Anyway - this blog will contain various Oracle SQL related tips, ideas and opinions. I do not promise a fixed posting schedule or even any regularity. But whenever I feel like it, there may be something new on here now and again :-)

Any scripts and snippets on this blog is for demo purposes only. You may use them at your own risk :-)

Thank you for stopping by...