As most people likely to read this blog will know, I am a great fan of the ODTUG Kscope
yearly conference for Oracle developers. In my opinion it is one of the absolute best places for awesome content, presenters, attendees and networking - all wrapped in one high quality package that's fun too.
Some Dutch developers (Erik van Roon
, Gert Poel
and more) and I had a little twitter discussion some time ago. (more...)
A recent question on the Oracle-L mailing list was about generating dates in a given period. If you had a string like 'MWF', all Mondays, Wednesdays and Fridays between the from- and to-dates should be generated.
That reminded me of a quiz on plsqlchallenge.com
I did on using DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING. I had created a table function to test calendar expressions - that might be useful for something similar to what was asked on the (more...)
It's Christmas time... It's a time for giving... It's a time for warm-hearted feelings...
But there are people battling for their lives against cancer, who may not have much energy left to enjoy the holidays. Almost everybody has family or friends whose life has been impacted by cancer. Let us all reach out however we can, help wherever we can, and let good thoughts go out to the victims.
All cancer is terrible - but (more...)
Som et alternativ til kaffemøderne i den danske Oracle brugergruppe DOUG forsøger vi efter idé fra min kollega Majken Sander
og undertegnede et nyt koncept uden præsentationer og foredragsholder, men i stedet lade deltagerne brainstorme og sparre med hinanden omkring at knuse et bestemt problem.
køres en aldrende XAL applikation med data i Oracle. Her skal re-nummereres pseudokey for 600 millioner rows pga. applikationen ikke kan håndtere integers over 32 bit. Det (more...)
Via Steven Feuerstein
I was asked to try and give advice concerning fastest way to parse CSV data in PL/SQL. The case was that they had a different database that could be setup to deliver data as a webservice serving either CSV, XML or JSON, and they wished to let their APEX application use PL/SQL to retrieve data from that other database via such webservices. They were not yet on 188.8.131.52.0 (more...)