What is new in Oracle Database 19.21 RU

Oracle Database 19.21 RU was just released! As soon as it is available in My Oracle Support to download, we also add it to ORAdiff app: https://oradiff.oracle.com/ So, what is new? You can check yourself by accessing ORAdiff website and comparing each section, but below I will give a summary of the main changes that …

Continue reading

LAOUC 2023 Slides

After 2 intensive weeks, the LAOUC Tour 2023 is over! It was the first tour after the 2019 pandemic and it was great to see all that legion of people interested in Oracle technologies. Over the 7 countries that I've visited during the tour, I gave the 4 sessions above: Secret Features of Oracle Data …

Continue reading

ORAdiff - Find the differences between two Oracle Database releases

We are happy to announce that ORAdiff is live! ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles. It reports differences in parameters, privileges, users and roles, reserved words, patch fixes, database homes, objects, and more. It can also be used to obtain an inventory …

Continue reading

Generate APEX application checksum in PL/SQL

In Oracle APEX, generating the application checksum is useful to compare if the application you have running in one workspace is an exact copy of the application running somewhere else. To create this checksum, you can go into Utilities -> Application Checksum. However, it is not very well documented how you could generate this checksum …

Continue reading

LOG(x,y) returning wrong results in some cases

I had a requirement in one tool that I was working to find whether a given table column was power of 2. The easiest way to check would be using the LOG(2,y). If the result was an integer, the number would be power of 2. 2^X = Y     ->     LOG(2,Y)=X And …

Continue reading