(mdinh) Note: Primary Database: cdb1_stby is because failover was previously performed.

(Stephen Cross) This article covers a common configuration pattern that I’ve been meaning to post for a while. When provisioning resources in Oracle Cloud Infrastructure (OCI), some resources, specifically IAM resources, can only be created in the Home Region.

(Bobby Durrett) This is nothing new, but I wanted to throw out a quick post to document it. If you have a sequence.nextval in the insert part of a merge statement the merge calls nextval for all the updated rows as well.

(David Fitzjarrell) Database replication is no longer restricted to Oracle-to-Oracle configurations; Oracle-to-cloud and Oracle-to-BigQuery are just two of the various options that can now be selected for replication configurations.

(Dimitri Gielis) If you are reading this blog post you are probably searching for an alternative for the deprecated multimedia (or intermedia) feature of the Oracle Database… and you are in the right post as APEX Media Extension is that replacement!

(Bobby Curtis) Recently I was exchanging emails with a few community members about Oracle GoldenGate Microservices. One of them commented on that Oracle GoldenGate Microservices was difficult to install; at the time, I was puzzled.

(Scott Wesley) The following where clause expression would normally return false, therefore the query would deliver no rows.

(Phil Wilkins) The API Platform when you configure IDCS to provide the option to authenticate users against a corporate Identity Provider such as Active Directory will automatically update the Management Portal Login screen accordingly.

(Richard Foote) In my previous post on Automatic Indexing, I discussed how the default index column order (in absence of other factors) is column id, the order in which the columns are defined in the table. In this post, I’ll explore if this changes if index compression is also implemented.

(Anand) I was recently asked how to get date of next Monday irrespective of which day of the week sql is executed.