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 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 184.108.40.206.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...