(Connor McDonald) My last post was about patching my home databases from 18.3 to 18.5 on Windows, and how I encountered a patch conflict when I tried to patch the JVM.
(Scott Wesley) It’s nearly 8am, you’re holding your favourite morning beverage, and you open yesterdays APEX tab, only to find this:
(mdinh) I have been patching a lot lately and wanted a fast and easy method to source Oracle environment.
(Andrejus Baranovskis) Oracle ADF BC by default is trying to reuse prepared SQL query from statement cache. It works this way when ADF BC runs with DB pooling off (jbo.doconnectionpooling=false).
(John Brady) I’ve said before in this blog how I find Python to be very useful for doing various things, including processing data to or from an Oracle database.
(Syed Jaffar Hussain) Today (14-Feb-2019) Oracle officially released the 19c docs and Oracle Database 19c for Exadata through edelivery channel. Since the news is out, Oracle community is busy talking about 19c availability and sharing articles about 19c etc.
(Connor McDonald) Contrary to wild rumours on the internet, it was not a fear of the number 13 that led to a numbering jump from version 12c to version 18c.
(Carlos Sierra) Doing a SQL Plan Baseline fleet cleanup, I wanted to get the SQL_ID give a SQL Plan Baseline. Long ago I wrote a PL/SQL function that inputs some SQL Text and outputs its SQL_ID .
(Scott Wesley) For quite some time I’ve been crafting multiple applications that, to the end user, appear as one.
(Kim Berg Hansen) Back in 2015 I experimented using ODCITable* functions to dynamically parse delimited text (see blog post here.)