• Kim Berg Hansen

    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...
  • Kim Berg Hansen

    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...
  • Kim Berg Hansen

    Analytic FIFO multiplied - part 1

    I have blogged before about Analytic FIFO picking as well as talked about it at KScope12 and will do again at UKOUG2012 . A few days ago Monty Latiolais , the president of ODTUG , had a need to do this - not just for one order which he already had developed...
  • Kim Berg Hansen

    A bit of fun expressing ratios

    Sometimes answering questions on the OTN forum leads to a little fun trying to be creative in SQL ;-) A user wished to express a ratio as 1:1 or 1:2. That lead to a little fun with CONNECT BY on DUAL for recursion. This is the SQL I ended up creating...
  • Kim Berg Hansen

    RANGE BETWEEN and leap years

    Answering a question on the OTN forum was a bit tricky to get an analytic sum using a RANGE BETWEEN that would handle leap years, but in the end I came up with a workaround that satisfies the requirement. Along the way I realized why there are two different...
  • Kim Berg Hansen

    Find your way with HttpUriType and Google Maps

    Recently I read Duke Ganote writing about using UTL_HTTP to get stock quote from Yahoo. (Duke must have a thing for authorities, particularly Marshalls of Legoredo ;-) Anyway, I posted a comment how to do a similar thing with HttpUriType. And that reminded...
  • Kim Berg Hansen

    Group by Groups

    For some time now I have struggled to efficiently "group by groups" on data containing references between our suppliers item numbers and the original equipment manufacturer (OEM) number. I can group those data by supplier and their item number...
  • Kim Berg Hansen

    Fiddling with MONTHS_BETWEEN

    A few days ago I answered a question on OTN SQL and PL/SQL forum that prompted me to fiddle around with MONTHS_BETWEEN. I did discover something new that I wasn't aware of while developing an alternative MONTHS_BETWEEN implementation. The forum poster...
  • Kim Berg Hansen

    INSERT ALL master/detail data from XML

    This is something I actually made for a quiz on PL/SQL Challenge , but I think the technique could be useful for others as well :-) The idea is you may have some master/detail data (in this case orders and orderlines) for which you get XML with such data...
  • Kim Berg Hansen

    Conway's Game of Life in a MODEL clause

    This post has no serious purpose. I was just fooling around with the MODEL clause when I got the idea that ITERATE could be used for modelling Conway's Game of Life. So that's what I did - just a little fun example of what MODEL can be used for...
  • Kim Berg Hansen

    Top selling items

    A classic task given to a programmer is to make a TOP-N report of some data. Often a TOP within each group of some defined grouping (department, country, product type, etc.) And many times the report should also include the percentage of the total - even...
  • Kim Berg Hansen

    Analytic sales forecast

    Analytic functions have been very helpful at my work. One of the good examples is trying to forecast next years sales for each item taking into consideration seasonal variations and whether the item has been going up in sales the last years or declining...
  • Kim Berg Hansen

    DATE and DST

    Recently on the ODTUG e-mail list ODTUG-SQLPLUS-L a user highcharge asked how to take daylight savings time into consideration when calculating number of hours between two DATE values. If you merely subtract the dates, twice a year you will be one hour...
  • Kim Berg Hansen

    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...
Page 2 of 2 (39 items) 12