By Patch ~ April 3rd, 2014. Filed under: Oracle, PL/SQL, SQL.

plsql_logoThere 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 the other day that makes perfect sense to do then you are running an Oracle 10g (or earlier) instance. I rewrote the code to use only the EMP and DEPT tables to protect the suspects and maybe innocent.

Continue reading »

Oracle PL/SQL Programming 6th edition by Steven Feuerstein

By Patch ~ March 13th, 2014. Filed under: Books, O'Reilly, Oracle, PL/SQL.

opp6_catI have reviewed the latest edition of Oracle PL/SQL Programming. This is not a book, at least for me, that I would read front to back. I use it mostly as a reference, but the great thing about this book is that you can also use this book to learn programming PL/SQL from scratch.

Continue reading »


By Patch ~ February 28th, 2014. Filed under: Oracle, PL/SQL.

After a presentation by Lucas Jellema I decided to try something with types in Oracletable_EMP. One of the issues posed in this presentation was that the type cannot include self-reference. Neither direct nor indirect.

Continue reading »


By Patch ~ February 4th, 2014. Filed under: APEX, Oracle, PL/SQL, SQL.


This year, from June 22 - June 26, the best convention in the world, ODTUG’s KScope14 will be held in Seattle, Washington. I am already looking forward to meeting some ‘old’ friends again, creating new friends and seeing some of the best content by presenters from all over the world.

Some of the presentations I am looking forward to:

In the Developer’s Toolkit track:

And of course my own presentation:

Pipelined Table Functions by Patrick Barel

And in The Database track:

And that is just two of the many tracks available. One of the great things I like about this conference is that you can switch between the different tracks whenever you see this fit. Suppose your main focus is The Database, but there seems to be something interesting in the APEX track, then it’s no problem to go see that presentation.

Only problem with this much great content is the chance of some good sessions to be in the same timeslot. This means you will have to make a choice which session to go to and which one to try and catch later, be it next year, maybe a webinar or an online recording.

APEX 5.0 Early Adopter

By Patch ~ February 1st, 2014. Filed under: APEX, Oracle.

The long awaited Early Adopter installation is finally available at You can request a workspace here to play around with the new version. I have just been playing around with it for about an hour an from what I’ve seen it’s a big change to what we’re used to since APEX 4.

Not only has the look an feel changed to flat ApplicationBuilder  ApplicationBuilder, but I think the biggest visible change is the new application builder. Where APEX 4.0 introduced the treeview builder, which was a big change from the component view we were used to before 4.0. I liked the treeview a lot better after just using it a little while. Now APEX 5.0 gives us an all new Page Designer. The interface looks a lot like the interfaces you will find in the current IDE’s like JDeveloper etc.

It takes a bit of searching to find everything I used in APEX 4 but I think I will get used to the new interface very soon and I will probably start wondering how I could have ever lived without it soon enough.