In my ongoing review of Oracle Database 23ai’s vector functions, there was some confusion about which distance functions are equivalent, what the aliases are for
Tag: oracle
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
Want 10053 traces? Can you query GV$ views?
If so, you’re in luck. You may have ALTER SESSION privileges in your database, but when you enable a 10053 trace and run your query,
Oracle Exadata Offloading Anomalies: How Much is DML a Factor?
I was testing a few of the functions identified in V$SQLFN_METADATA to see if some of the REGEXP-related functions were offloadable (they are!) and the
Can Exadata take you Beyond “Infinity and Beyond” with Non-Numbers?
Let me clarify… in a previous post, I showed some of the arithmetic around some of Oracle’s floating point literals and how that arithmetic didn’t
In “Case” you missed it: Part 1
And you probably didn’t miss it, since I just posted it. A question came up a couple times recently, “Do WHERE clauses with CASE expressions
All Kinds of Exadata Stuff 