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
Tag: Oracle Database
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
On Exadata, Sometimes Looks Can Be Deceiving
Sometimes performance on Exadata can be so good that you don’t think there’s a problem! I recently ran into a situation where an Exadata offloaded
IOTs on Oracle Database 23c: What’s old is new again? Part 2
In part 1 of the mini-series on Oracle Database Index-Organized tables (IOTs), I reviewed some of the pitfalls of using IOTs, especially on an Exadata
Sometimes I Can’t Live Without ARCHIVELOG Mode and I Can’t Live With It
The title of this article does not have a typo. ARCHIVELOG mode has been a foundational element of Oracle Database for every version I can