(Hemant K Chitale) Continuing our investigation of the FBDA architecture.

(Scott Wesley) Looking for way to apply analytical functions to your APEX applications?

(Alexey Filanovskiy) Definitely not all queries could be offloaded and not all part of the SQL could be executed on the cell (storage) side. Some of the queries could be pretty complex and could have PL/SQL inside.

(Kellyn Pot’Vin-Gorman) As we migrate to the cloud, secured credentials are starting to become a standard in most DBAs worlds. If you don’t take the time to understand ssh keys and secured credentials, well, you’re not going to get very far in the cloud.

(Jeff Smith) This trick’s title might actually be longer than the content – so guaranteed QUICK read!

(Hemant K Chitale) One of the points in the previous post was how ADD and DROP Column commands are supported in FBDA.

(Vineet Marwah) Folks have often commented to me that Table Compression (and Advanced Row Compression) are great at helping to reduce the storage footprint of an Oracle database by a factor of 2x-5x, but Oracle shouldn’t forget about the indexes.

(Kris Rice) Seems I’ve never posted about PL/SQL based REST endpoints other than using the OWA toolkit. Doing the htp.p manually can give the control over every aspect of the results however there is an easier way.

(connormcdonald) I was recently asked when presented with a query along the lines:

(Scott Wesley) I came across the need for an UNPIVOT today that require fairly basic syntax, so this is me noting it for later.