(Dimitri Gielis) When configuring some Oracle REST web services through Oracle APEX, I got confused, so I thought to quickly write down, so I don’t forget for the future.

(Richard Foote) Julian Dontcheff recently wrote a nice article on the new Automatic Index Optimization feature available in the upcoming Oracle Database 20c release (I’ll of course blog about this new 20c feature in the near future).

(Connor McDonald) This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”. After some back-and-forth discussions it turned out that the business need under the requirement was managing bit strings.

(mdinh) Followup from How To Create New Standby Using Active Standby Duplication From Existing Standby

(Sidhu) There are two common scenarios when we may need this:

(Frederique Retsema) You might have noticed that we skipped the API Gateway up to now [1]. I will write two blogs about the API Gateway.

(David Fitzjarrell) A long-standing discussion in Oracle forumns and newsgroups has been the efficiency of using coun(*) to returnn a rowcount from a given table.

(Jang Vijay Singh) A number of use-cases can be implemented cleanly using a recursive approach. This post is not to debate the pros and cons of recursion versus looping but provides a simple approach to achieve this.

(Martin Bach) As promised in an earlier post here are my notes about installing Oracle Restart with ASM Filter Driver (ASMFD) 19c on Oracle Linux 7 using UEK 5.

(mdinh) After an upgrade completes with either Deploy or Upgrade modes, AutoUpgrade performs postupgrade checks.