Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.” 2. Step-by-Step Guide to Creating a New Forms Server in…
Category: SQL
Oracle
Read more
November Reading
Recent Blogs I’ve Read: 1. How Can a Data Breach of an Oracle Database be Managed and Analysed? Pete Finnigan asks, “If you become the latest victim of a data hack and your Oracle database is compromised then what do you do?” 2. Applying the first Monthly Recommended Patches (MRP)…
APex
Read more
Weekly Update w/c 4th March 2024
Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Analytics
Read more
Monthly Round Up
This blog by Federico Venturin links to his article ‘Handling Fine-Grained Data Visualization Permissions in Oracle Analytics Cloud.’ It goes through: In his conclusion, he writes, “Until now, the all-or-nothing approach for handling permissions in Data Visualization posed a significant hurdle to its widespread adoption since administrators understandably preferred to…
Monthly News
Read more
What’s going on this February?
Blogs of the month Patching my environments with the January 2023 Bundle Patches Mike Dietrich shares information about January’s Security Alert and gives a quick overview of the patch bundles he intends to apply to his 19c and 21c environments. 2. Fixing up oem 11g This blog begins with, “Although oracle enterprise…
Conference
Read more
Back to School
Have you had a good Summer? Here’s a round up of the blogs that have caught my eye over July and August: Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
APex
Read more
Best of last year
Here is my take on the good reading stuff from last year. Obviously there is a bit of a covid theme to a lot of the blogs I read, but also some great tech updates. Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app Read about how…
APex
Read more
End of Summer…
Today is the last working day of August (It’s a UK Bank Holiday Monday on 31st August…) next week we will be into the beginnings of September and Autumn. Slow down over the Bank Holiday and read some of the latest blogs and articles or watch some videos…. Blogs of…