Patrick Barel

Author

Sometimes the best way to see the familiar is to go far from it – Wisdom of the desert In previous articles (collections I and collections II) I described the different types of collections, their possibilities and their limits. One of the limits was the possibility to use an Associative Array in a SQL statement. If you are building your… Continue Reading →

12c, All Things Oracle Full Articles, Oracle Database, PL/SQL

Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we looked at the result cache for PL/SQL Code We can also use this same technique when our function depends on tables (or views). Let’s create a simple table, add some data and a simple, slow function: CREATE OR REPLACE FUNCTION… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things faster. Sure you can use more CPU power or more memory in the database server, but there’s a limit to that approach. Be it the amount of money being spent, the limits of the [current] CPU power or other limits…. Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

Admit that your own private Mount Everest exists. That is half the battle. – Hugh Macleod Other options In the example we used pretty much the minimum number of parameters to make it work. There are more parameters and options available. For example UPDATE_CHECK. This does pretty much the same as WITH UPDATE CHECK in views. If you insert or… Continue Reading →

10g, 11g, 12c, 8i, 9i, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

Views When working with views you have several options to hide some of the data. In the article on views I have told you about the way to hide columns from the table. By adding a predicate (where clause) to the view, you can restrict the rows a user sees. This would imply creating different views for different (groups of)… Continue Reading →

10g, 11g, 12c, 8i, 9i, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

Views

Patrick Barel on 05 June 2013 with 1 comments

Success always occurs in private and failure in full public view. – Unknown When working with views you have several options to hide some of the data. Of course there is the possibility not to select certain columns of data in the view. This way, the user of the view doesn’t even have to know this column even exists. You… Continue Reading →

10g, 11g, 12c, 8i, 9i, All Things Oracle Full Articles, Oracle Database, PL/SQL

Technology is dominated by two types of people: those who understand what they do not manage, and those who manage what they do not understand – Putt’s Law We are always working with data and their datatypes. In the tables we constrain the data by their datatype. For instance, we create a price column of type NUMBER(4,2) telling the database… Continue Reading →

10g, All Things Oracle Full Articles, Database Development, PL/SQL, Troubleshooting, Uncategorized

  Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for the pages: they can either be public or protected. Mostly you will build applications using a combination of the two. Some pages will be publicly available, like the landing page of your application, but there will also be pages… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development

Greatness is a transitory experience. It is never persistent. – Collected Sayings of Muad’Dib by the Princess Irulan In the previous article we saw how we could have different version of the code in different editions of the schema. But what about the tables? They are not editionable? This article will show you how to work ‘around’ that. Data Most… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Development, Oracle Database

A process cannot be understood by stopping it. Understanding must move with the flow of the process, must join it and flow with it. – Frank Herbert, Dune (First Law of Mentat) One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality allows for near zero downtime when performing an… Continue Reading →

11g, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL