Author: Patrick Barel

If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. …

Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a …

Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database …

There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL, do it in SQL. I came across some code …

Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database …

After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed in this presentation was that the type cannot self-reference. …

The long awaited Early Adopter installation is finally available at http://apexea.oracle.com. You can request a workspace here to play around with the new version. I have just been playing …

On February 13th I will be giving a webinar on Edition Based Redefinition hosted by Red Gate Software.I will be talking about how EBR can be used. It will …

SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the …

Afgelopen dinsdag 4 oktober waren Andre van Winssen en ik de aangewezen personen om een presentatie bij de OGh te verzorgen. Andre vertelde in ongeveer een uur het een …

At the KScope conference in Long Beach, CA one of the most interesting sessions I attended was a session called: Five Features You Ought to Know About the Oracle …

Last week I attended my very first ODTUG KScope conference in Long Beach, California. I have  attended conferences by ODTUG before, but they were never this broad. Sunday On …

Have you ever wanted to replace a character in a string just by position? I needed this the other day and IMHO there is no way in Oracle PL/SQL …

I have had trouble with a certain view I have to create at the customer site I am currently working at. The view involves 3 SQL queries combined by …

After visiting the OPP/APEXPosed conference in Brussels I decided to write a post on how to create a relatively simple dynamic action in APEX. When you are working with …

I have been invited to deliver two talks on performance at the OPP conference, November 10th and 11th in Atlanta. The topics I will address are Pipelined Table Functions …

Last Wednesday Quest organized a seminar in Amsterdam on the performance of the Oracle database and the programs you write for it. There were three presentations. Development Application Testing …

Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer. I am trying the same things in PL/SQL Developer to see if …

When I was in Chicago for the OPP2008 and APEXposed event I talked to someone who seems to have trouble understanding bulk operations in PL/SQL. I helped him out …

Op 3,4,10 en 11 december organiseert AMIS weer de 7Up training. In vier dagen worden de deelnemers wegwijs gemaakt in de nieuwe mogelijkheden die Oracle biedt. Veel mensen zijn …

Yesterday evening we had a nice, interactive, session about PL/SQL Developer. Theo Tol (BI4U) came by to tell us more about the tool and how it can be used. …

In het midden van de 90-er jaren waren er heel weinig en vrij beperkte ontwikkeltools beschikbaar voor het ontwikkelen van PL/SQL. Tegenwoordig is dat heel anders en zijn er …

When I was presented with the possibilities of Rulegen it made me wonder: How can these rules be tested. Rulegen is a tool to create rules in the database …

I ran into an issue at a customer site where certain triggers were disabled in the database where they should be enabled. It appeared that an update script, that …

At AMIS they are working on teaching a lot of us about the fundamentals of SOA. We just had the first couple of events in which Lucas and Peter …

On February 21st I did a presentation on CodeGen at AMIS. Just a short presentation on what is possible using this great tool. I have created a couple of …