Hemant's Oracle DBA Blog

 Oracle 26.1 now allows using an Expression in the Partitioning Clause.  In earlier releases, you could do this with a Virtual Column defin...

 Oracle 26.1 introduces the new FILTER clause that can be used in aggregations.   Thus, for example, in a SUM aggregation you can use FILTER...

I have created a Video Demo of the Retrieval for RAG , based on what I have posted here blog posts.

 Updating my previous demo that was in 23ai  to run in  Oracle AI Database  26ai with two enhancements : vector_memory_size  set to 512MB ...

 In response to a comment on a previous Blog Post RMAN Backup of a Standby Database , I show incremental Backups as well below RMAN> bac...