Managing performance on Exadata can be tricky, partly because you’re using a RAC environment with two or more database nodes managed using Database Resource Manager
What’s the Metadata for a Query in Oracle Database 19c?
A cross-platform developer asked me if there was an Oracle equivalent to a procedure for returning the columns with datatypes and precisions for any given
Blockchain Tables in Oracle Database 23c: Time Travel and Wormholes Part 2
In Part 1 I demonstrated the basic functionality of blockchain tables in Oracle Database 19c, otherwise known as V1 blockchain tables. They are available if
Blockchain Tables in Oracle Database 19c: Time Travel and Wormholes Part 1
Blockchain tables, now available in Oracle database 19c with a later RU and a higher COMPATIBLE parameter value, can act as an electronic ledger and
More Powerful FLOOR and CEIL Functions in Oracle Database 23c
The FLOOR and CEIL functions have been enhanced in Oracle Database 23c (Developer’s Edition) to allow dates, timestamps, and intervals in addition to just numeric
Oracle Database 23c: George Boole Finally Makes an Appearance
In a previous post, I was lamenting the lack of a Boolean Data Type in Oracle Database. As of Oracle Database 23c, Boolean Data Types