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 220.127.116.11.0 (more...)
Previously I've demonstrated how to use function XMLTABLE to query Google maps routing directions
. Now Oracle version 18.104.22.168.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...
For this test we'll use the Google maps geocoding rather than routing directions and try to geocode the address of Oracle headquarters. If we call the Google api with instructions (more...)
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 :-)
Sung to the tune of the old Nat King Cole classic
Like the speed of light my query go
Column aggregates just happen so
Has data been more...
Is forever more
Row based access, it's a dinosaur
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.
This was my fifth consecutive KScope and I plan to go every year. That is one awesome konference for developers and it just gets better every year. I'll be at KScope15
in Florida for sure! I had a great (more...)
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.
I'm creating a nested table type and a table with a column of that type (more...)