OUGN Spring Conference 2016

I'm back after one of the best ocean voyages ever - the OUGN Spring Conference 2016. That conference is arranged by Oracle User Group Norway and is two days from Thursday before lunch-time to Saturday before lunch-time. The special thing is, that it all happens on board a cruise ship that uses 20 hours to sail from Oslo, Norway to Kiel, Germany - stays in Kiel 4 hours - then 20 hours to sail back. (more...)

The upcoming year

Right smack in the middle of the busiest time of the year for the business (this time of year we sell fireworks for New Year) I have opportunity to reflect a bit on the upcoming year and what 2016 will bring of challenges and joys.

Of course things will happen in the Oracle world that'll indirectly influence my year, as always. Not always possible to predict here near the start of the year, but most (more...)

Vessel Fuel Consumption – or Restarting Running Sum

I got a question recently from Morten Braten whether my FIFO analytic techniques could be helpful for calculating the value of fuel consumption for cargo vessels. It turned out not to be quite the same, but similar. Analytic functions definitely could help.

I'll show how in two parts. First this blog post will calculate the fuel consumption in quantity, then part two will calculate the value by FIFO.

So let's setup a slightly simplified version (more...)

Bloggers Meetup at #OOW15

The last time I went to Oracle OpenWorld, I hadn't started blogging yet. Now I think it fair to call myself "blogger", even though I don't blog very regularly.

So I will try to attend the Bloggers Meetup:

http://www.pythian.com/blog/oracle-openworld-2015-bloggers-meetup/
https://community.oracle.com/events/1099

I have heard a lot of good about it, so I am looking forward to see for myself ;-) Viewing who has RSVP'ed at either link, I know I spot some (more...)

Oracle OpenWorld 2015

In 2 days time I fly off to San Francisco for Oracle OpenWorld 2015. Last time I went to OpenWorld was 2008, so I'm looking forward to a re-visit and see how much bigger it has become :-)

Like everybody else I've been making a schedule for the week. Of course things will happen to change the schedule along the way, but some things I definitely have on the must-do list...

Thank You for the Votes

The Oracle Database Developer Choice Awards voting is now closed.

I thank all of you who voted for me. It was an honor and privilege just to be nominated, and then even getting votes from somebody, well that feels good :-)

My final ranking is middling, but the competitors were all worthy and good people, so I have no complaints :-)

CATEGORY  NAME              FINAL_RANK POSITIVE_VOTES
--------- ----------------- ---------- --------------
apex Morten Braten 1 186
apex (more...)

Oracle Database Developer Choice Awards Voting Status

The Oracle Database Developer Choice Awards voting will go on until October 15th 2015. If you haven't already, you should go vote now!

Here is the present status of how many votes have been submitted per category, including how many votes the category has increased with since "approximately yesterday" (since last time I downloaded the data, which I plan to do approximately daily ;-), and including how many votes the category has increased with since (more...)

Scraping and querying Oracle Database Developer Choice Awards votes – Part 2

In Part 1 I demonstrated how to "scrape" data from the live webpages with the votes of the Oracle Database Developer Choice Awards. Unfortunately those webpages are not ideal for scraping, so I promised a workaround. Here I do a semi-manual scraping af data by using a browser to retrieve the actual HTML, save it to a file, and then let the code parse out the data from the file.



In the live version, the (more...)