Optimistic Row Locking in Oracle Application Express (APEX)
As is common with stateless web-based applications, Oracle Application Express (APEX) utilizes an Optimistic locking mechanism when updating data via …
Oracle BI Cloud Service (BICS) – Going Beyond SampleApp
One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to …
Monitoring Oracle Data Integrator (ODI) Load Plan Executions with BI Apps
Update – 22/08/2018 I have added a simple version of the Load Plan Monitor to GitHub (Available Here). Please provide …
Integrating external command line tools with Oracle data
One thing I find interesting to explore is the integration of different tools with Oracle which may not always be …
Oracle 12c – Adaptive Execution Plans
Having not done a great deal with Oracle 12c, I was quite excited today to see an adaptive execution plan …
Selectively Enabling Fields/Flexfields on a Query Only Oracle Form Using Personalizations
Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted …
Generating Rows Automatically in Oracle
Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to …
Best Practices – Extending E-Business Suite with Oracle Application Express (APEX)
This post follows on from a previous post which describes how to seamlessly integrate your APEX and E-Business Suite environments …
Extending E-Business Suite with Oracle Application Express (APEX)
Traditionally E-Business Suite projects have consisted of a number of technologies – Oracle Forms, OAF, Reports, XMLP, SQL*PLUS and so …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 2
If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common …