(Jeff Smith) Stepping through your PL/SQL code is fun – but often you want to be able to ‘jump to’ a specific iteration of a loop or maybe when a certain condition evaluates to true.
Tag: Oracle
Oracle 19c Automatic Indexing: A More Complex Example (How Does The Grass Grow)
(Richard Foote) In this post I’m going to put together in a slightly more complex SQL example a number of the concepts I’ve covered thus far in relation to the current implementation of Oracle Automatic Indexing.
Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0
(Mike.Dietrich) Last week I recorded seminars – and I wanted to garnish the Performance part with demo recordings from our Hands-On Lab.
Rolling forward a Physical Standby
(Marco Mischke) Today I am going to write about one of my favorite new features for Oracle Data Guard which was introduced with version 12.1. For this post I refer to primary and phyiscal standby database simply as primary and standby for the sake of readability.
Code re-use … Not a substitute for brain use
(Connor McDonald) I was doing some code review today of a PL/SQL package, and came across a routine to generate a list of employees for a department.
#768 OIC –> HCM Data Extract Processing Pattern
(Niall Commiskey) Simple scenario here –
Oracle Cloud & Third party tools
(Syed Jaffar Hussain) There have been several buzz words and offerings since the invention of Cloud concepts. We have been hearing of Private Cloud, Public Cloud, Hybrid cloud and more recently multi-clouds concepts and offering from many leading cloud market players.
Saved Interactive Reports, Lost and Found
(Jeffrey Kemp) We had just gone live with a fairly big system move + upgrade – a suite of APEX applications shifted from one database instance running APEX 5 to another instance running version 19.1.
Oracle Always Free Oracle Database upgrades
(Dimitri Gielis) This post is a continuation of the series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.
Oracle Real Memory Usage
(Liron Amitzi) I’ve been struggling with that for a while now, so in this post I’d like to explain what I’ve found so far and what I’m missing. If you can help me to complete the picture that would be excellent!