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

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 as well.

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

I am a regular article contributor to OTech Magazine, an independent web magazine on Oracle technology. The magazine is issued quarterly and definitely a recommended read for Oracle professionals.

I have joined the fabulous community of ODTUG and attended the Kaleidoscope conference since 2010. In 2012 I did a presentation on analytic functions at KScope12 in San Antonio. At KScope14 in Seattle I presented on http/ftp/webservice calls from the database as well as on analytic functions.

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 KScope16 in Chicago, 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...