Patrick Barel Collections in 12c Sometimes the best way to see the familiar is to go far from it – Wisdom of the desert In... 21 October 2014 9 min read
Patrick Barel Result Cache (Part 2) Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we... 04 February 2014 5 min read
Patrick Barel Result Cache (Part 1) First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things... 28 January 2014 5 min read
Patrick Barel Virtual Private Database (Part 2) Admit that your own private Mount Everest exists. That is half the battle. – Hugh Macleod Other options In the... 04 September 2013 8 min read
Patrick Barel Virtual Private Database (Part 1) Views When working with views you have several options to hide some of the data. In the article on views... 21 August 2013 9 min read
Patrick Barel Views Success always occurs in private and failure in full public view. – Unknown When working with views you have several... 05 June 2013 5 min read
Patrick Barel PL/SQL Subtypes Technology is dominated by two types of people: those who understand what they do not manage, and those who manage... 03 April 2013 6 min read
Patrick Barel Custom Authentication in APEX Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for... 09 January 2013 6 min read
Patrick Barel Edition Based Redefinition – Part 1 One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality... 25 October 2012 7 min read
Patrick Barel Checking for NULL with Oracle SQL The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert... 30 August 2012 7 min read
Patrick Barel ANSI SQL if you can’t beat them, join them. Gregory Y. Titelman Since Oracle 9i, Oracle SQL supports the ANSI SQL... 18 July 2012 6 min read
Patrick Barel Caching Part 2 Never trust a computer you can’t throw out of a window. Steve Wozniak Deterministic Function Caching A function is considered... 23 February 2012 1 min read
Patrick Barel Invoker Rights Part 2 Kindness is the beginning of cruelty Frank Herbert Syntax If you check the syntax for the different program objects you... 25 January 2012 4 min read
Patrick Barel Invoker Rights Part 1 Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for... 08 December 2011 4 min read
Patrick Barel Dynamic Show/Hide in APEX Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain... 31 October 2011 4 min read
Patrick Barel Bulk Processing in Oracle Part 2 The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray... 27 September 2011 4 min read
Patrick Barel Collections in Oracle Part 2 “The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This... 02 September 2011 6 min read
Patrick Barel Collections in Oracle Part 1 “The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of... 19 August 2011 5 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be... 20 July 2011 2 min read
