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
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 [...]
(Dutch) 7Up cursus.
19/11/2008 - 10:55 am
Posted in Database, Oracle | No comments
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 met Oracle 7 begonnen en werken nu met een recentere versie van de database (9, 10 of 11), maar bouwen nog steeds PL/SQL code en SQL [...]
KC: PL/SQL Developer
9/10/2008 - 3:36 pm
Posted in AMIS, Devel. + PL/SQL tools, KC Oracle Development Tools, Oracle | 1 comment
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. There was some nice information on the different windows for the different tasks and then there where some tips on how he thinks it’s easier to [...]
(Dutch) Woensdag 8 oktober: KC PL/SQL Developer onder de loep (met spreker Theo Tol)
29/9/2008 - 6:11 am
Posted in Devel. + PL/SQL tools, KC Oracle Development Tools | 1 comment
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 verschillende leveranciers van IDE’s voor het ontwikkelen van en beheren van databaseobjecten en databasecode. Toad for Oracle van Quest en SQL Developer van Oracle zelf zijn [...]
Testing Rulegen using Codetester
3/6/2008 - 10:14 pm
Posted in Database, Devel. + PL/SQL tools, Oracle | No comments
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 by just typing in some SQL queries. Rulegen will then use this input to generate a couple of triggers and a package to enforce these rules. [...]
Triggers…
11/5/2008 - 4:30 pm
Posted in Database, Oracle | 4 comments
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 is run every night, first disables all triggers on a couple of tables. Then does what it needs to do, without the overhead of the trigger [...]
My SOA architecture and webservices mindset…
14/3/2008 - 3:27 pm
Posted in Oracle, Software Development, XML | No comments
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 taught us stuff about XML and BPEL. To get an idea of what SOA and webservices actually are and how we should work with them.
At the [...]
