As is common with stateless web-based applications, Oracle Application Express (APEX) utilizes an Optimistic locking mechanism when updating data via the built in Automatic…
Read more →One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to leverage the features of…
Read more →Update – 22/08/2018 I have added a simple version of the Load Plan Monitor to GitHub (Available Here). Please provide any feedback via GitHub.…
Read more →One thing I find interesting to explore is the integration of different tools with Oracle which may not always be obvious. For example, take…
Read more →Having not done a great deal with Oracle 12c, I was quite excited today to see an adaptive execution plan arise from a very…
Read more →Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted a form within Oracle…
Read more →Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to generate a row for…
Read more →This post follows on from a previous post which describes how to seamlessly integrate your APEX and E-Business Suite environments – if you missed…
Read more →Traditionally E-Business Suite projects have consisted of a number of technologies – Oracle Forms, OAF, Reports, XMLP, SQL*PLUS and so on. Each of these…
Read more →If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common theme – indexes. Whilst this…
Read more →