Some things to share…

By Patch ~ May 23rd, 2014. Filed under: APEX, Oracle, PL/SQL, SQL.

I have been awfully quiet on my blog lately. I think that is because I have been busy with other things, like my garden and stuff like that. There are some ‘techie’ thing I have done in the meantime, though,

Tech14-Ive_SubmittedI have submitted a couple of abstracts for Tech14. Hope at least one of them gets selected. I really like presenting and if it is in a different country, that is just a plus. That way I get to see something of the world while I am still able to do this, considering my illness.

ODTUG_Kscope14On a shorter timeframe, I will be presenting at KScope14 this year. I will be nice to see my friends in the US again. If you are in the neighborhood of Nieuwegein and you want to some of the sessions, but cannot make it to Seattle, Amis-logo-kleinmaybe you can attend the KScope14 preview at the AMIS office on June 12th.

Hope to see you at either one of these events.sftilt80

Oh, and if you have a moment to spare and you know your way around at SQL - PL/SQL - APEX or some other language/technologies, maybe you can sign up at the GivHub and help Steven Feuerstein.


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.