Weblog for the AMIS Technology corner
Patrick Barel
Patrick Barel is a PL/SQL Developer for AMIS Services in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog and on his own blog http://blog.bar-solutions.com/.
Posts by Patrick Barel
OGh bijeenkomst 4 oktober
9/10/2011 - 3:51 pm
Posted in AMIS, Database, Devel. + PL/SQL tools, Oracle | No comments
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 en ander over Application Contexts en het gebruik van DBMS Crypto. Een deel uit de masterclass die hij bij AMIS verzorgt.
Ik hield mijn presentatie over [...]
Oracle Scheduler, the things you ought to know
20/7/2011 - 7:39 am
Posted in Devel. + PL/SQL tools, Oracle | No comments
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 Scheduler by Eddie Awad. It was a nice presentation where I actually learned stuff I didn’t know. At least not in relation to the Scheduler.
ODTUG KScope 2011
8/7/2011 - 10:07 am
Posted in Database, Devel. + PL/SQL tools, Oracle | No comments
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 Sunday I attended the APEX symposium. It was nice to see that APEX is being developed by a rather small, but geographically dispersed, group of people. Between them, [...]
Replace by position
8/6/2011 - 11:21 am
Posted in Database, Devel. + PL/SQL tools | 2 comments
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 to do this, so I decided to write this my self.
Pipelined Table Functions
26/11/2010 - 3:45 pm
Posted in Database, Oracle | 8 comments
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 using a UNION ALL, since the separate queries are mutually exclusive. Using the UNION ALL makes it a bit faster since [...]
Dynamic Actions in APEX
5/11/2010 - 3:18 pm
Tags: apex, password
Posted in Devel. + PL/SQL tools, Oracle | 5 comments
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 password fields your only visual check to see if the entered text in both fields match may be the number of characters entered. Of course you [...]
OPP is coming to Atlanta
16/9/2009 - 9:23 pm
Posted in Devel. + PL/SQL tools, Oracle | No comments
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 and Optimizing SQL with Collections. I will be among some of the best experts in the PL/SQL world, including Steven Feuerstein, Bryn Llewellyn and many others. [...]
Quest Software’s Toad and Oracle Performance Seminar
6/2/2009 - 4:55 pm
Posted in Database, Oracle | No comments
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
Database maintenance
Development
The main issue in this presentation was that you should care about performance as early as possible in your development. It is much cheaper (time and money wise) [...]
Code refactoring…
14/12/2008 - 3:01 pm
Posted in Devel. + PL/SQL tools, Oracle | No comments
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 this does do the trick.
Bulk Operations in PL/SQL
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 by providing a test/demo script, that shows how it could be done. First of all, one of the most important rules of thumb that I got [...]
