Wednesday, September 10, 2014

JSON_TABLE or XMLTABLE - comparison with geocoding

Previously I've demonstrated how to use function XMLTABLE to query Google maps routing directions. Now Oracle version 12.1.0.2.0 has function JSON_TABLE to do similar querying on JSON data rather than XML data. So let's try that out and spot some differences...

Tuesday, August 26, 2014

Unforgettable In-Memory

Inspired by Maria Colgans quest for In-Memory bumper sticker slogans for OOW14, I couldn't resist a little fun. Musical readers should stop reading now :-)


Saturday, June 28, 2014

KScope14 - on my way home

For some reasons I got lounge access here at Seattle airport when going home fra KScope14. So I can use the last couple hours here lounging comfortably writing a few words about an awesome week here.

Monday, June 23, 2014

MEMBER OF comparison of PL/SQL and SQL

In the Kscope14 sunday symposium today, Steven Feuerstein explained that MEMBER OF syntax was slow in SQL and fast in PL/SQL. I challenged him that perhaps it was missing indexes on the nested table? My mistake - I got the task of testing it and see if that was the case... So I tested and was surprised at the answer.

Saturday, June 14, 2014

Tuesday, May 13, 2014

Mini-KScope in Nieuwegein


Can't wait until KScope14 in Seattle?

Or can't make it to Seattle?


Then you can see some of the presentations at a preview at the AMIS offices in Nieuwegein, where some of the KScope14 presenters will try out their presentations in Database development, APEX and ADF tracks. I've been invited to do my presentation on analytic functions, so I'll be there ;-)

It'll be Thursday June 12th 2014. See the agenda here and more details (in Dutch) and registration here.

See you there...

Wednesday, December 11, 2013

See you all in Seattle

In June 2014 I hope to see a whole lot of you at ODTUG's awesome conference Kscope14...


You will not regret going to Kscope14. There is a ton of great content and loads of awesome brainpower to pick ;-) And if you can find the time for it in between all the great stuff, you might consider attending one of my two presentations:
  • Analytic Functions - Advanced Cases
Analytic functions can often help you using data across rows in ways that allow you to solve tasks that otherwise might have called for slowly using the data one row at a time procedurally. The presentation explains a set of advanced usecases of analytic functions showing use of RANK, DENSE_RANK, ROW_NUMBER, RATIO_TO_REPORT, LAG, REGR_SLOPE, ROWS BETWEEN, and more to efficiently solve actual real life tasks, such as top selling items, picking by FIFO, picking route, forecast sales, and more.
  • External Data via HTTP, FTP, Webservices
There are many ways you can access external data from within the Oracle database. The presentation will show ways of using HttpUriType, UTL_HTTP, JPUB, UTL_FTP, UTL_DBWS, APEX_WEB_SERVICE to retrieve external data. Calling SOAP or REST webservices or proprietary formats over http or https (SSL) or FTP will be discussed and shown. There will be demos of some of the method combinations - how many will depend on time available ;-)