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 126.96.36.199.0 so they did not have JSON_TABLE, and they seemed to find that do-it-yourself parsing of CSV data was the fastest. Did we have any idea of a faster way?
Tuesday, September 23, 2014
Wednesday, September 10, 2014
Previously I've demonstrated how to use function XMLTABLE to query Google maps routing directions. Now Oracle version 188.8.131.52.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
Saturday, June 28, 2014
Monday, June 23, 2014
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
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...