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

Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c)

Oracle Virtual Private Database (VPD) advanced policy options and Data Redaction - additional DBMS_RLS.ADD_POLICY parameters for fine-grained access control, and...

04 September 2013 9 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

Register for Simple Talk

Patrick Barel

Patrick Barel's content

Collections in 12c

Result Cache (Part 2)

Result Cache (Part 1)

Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c)

Virtual Private Database (Part 1)

Views

PL/SQL Subtypes

Custom Authentication in APEX

Edition Based Redefinition – Part 1

Checking for NULL with Oracle SQL

ANSI SQL

Caching Part 2

Invoker Rights Part 2

Invoker Rights Part 1

Dynamic Show/Hide in APEX

Bulk Processing in Oracle Part 2

Collections in Oracle Part 2

Collections in Oracle Part 1

Working with Table Functions in PL/SQL