Weblog for the AMIS Technology corner
Alex Nuijten
This user hasn't shared any biographical information
Posts by Alex Nuijten
Sneak Peek and what can come of it
26/10/2009 - 3:00 pm
Posted in Database, Devel. + PL/SQL tools, General, KC Oracle Development Tools, Oracle | 1 comment
Last Tuesday we did a Preview of the upcoming OPP (Oracle PL/SQL Programming) Conference which will be held in Atlanta, Georgia soon.
This preview took place in our office in Nieuwegein, The Netherlands. About 17 people attended this free preview. At regular intervals we do free "Knowledge Center" presentations. Keep a close eye on our Agenda [...]
DELETE in the MERGE statement
29/7/2009 - 10:20 am
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, KC SDPL, Oracle | 1 comment
The Merge statement was introduced in Oracle 9i and improved upon in Oracle 10g. In Oracle 9i only the INSERT and UPDATE parts were supported, in Oracle 10g DELETE was added. The "merge_update_clause" and "merge_insert_clause" became optional. The basic syntax for the MERGE statement:
DELETE can only occur in the "merge_update_clause" of the above schema. This [...]
My ODTUG Kaleidoscope 2009
1/7/2009 - 8:00 pm
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, KC SDPL, Oracle | No comments
Every year ODTUG – Oracle Development Tool User Group – organizes a conference, called Kaleidoscope. This time it was in Monterey, California.
If you have never been to this conference, you are missing out on something great. A lot of great presentations, great food, lots of time to network and meet a lot of great people.
Anyway, [...]
Business Rule: Only One Clerk per Department – 11g Style
19/12/2008 - 8:58 pm
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, KC SDPL, Oracle | 3 comments
During the 7Up workshop, a workshop geared towards experienced developers who want to get up to speed with everything that happened in Oracle since release 7, one of the “tricks” that passes by is how to implement the Business Rule:
Only one Clerk per Department is Allowed
The way we show how to declaratively implement this Business [...]
Subquery Factoring in Oracle 11g
5/12/2008 - 12:27 pm
Posted in Database, Devel. + PL/SQL tools, KC SDPL, Oracle | 2 comments
For the last two days the AMIS 7Up Workshop took place in our office in Nieuwegein. The training consists of two SQL and another two days of PL/SQL. During the first two days a lot of SQL subjects are reviewed.
One of them is Subquery Factoring, better known as the "WITH clause". Subquery Factoring lets you assign a [...]
Referential Integrity with Virtual Columns, the Sequel
16/7/2008 - 3:43 pm
Posted in Database, Devel. + PL/SQL tools, KC SDPL, Oracle | 1 comment
The comments on the blogpost on Referential Integrity with Virtual Columns lead to this entry.
As a recap: In the above mentioned blog post I showed how you can use a Virtual Column – a new feature of the Oracle 11g Database – to disect a composite value and use part of it in a foreign [...]
Referential Integrity with Virtual Columns
15/7/2008 - 11:47 am
Posted in Database, Devel. + PL/SQL tools, KC SDPL, Oracle | 6 comments
During ODTUG, a couple of weeks ago, Tom Kyte did a presentation on the "Top 10 11 things about Oracle 11gR1". The presentation can be downloaded from asktom.oracle.com. He started by saying the Oracle 11g Release 2 can be expected the end of this calender year.
One of the things he showed was a way [...]
Instrumentation
9/7/2008 - 9:06 am
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, Oracle | No comments
During the ODTUG conference in New Orleans, there were multiple sessions for the Development/DBA. As I consider myself a developer with a great interest in the database, I love going to sessions like these.
One of the recurring themes was Instrumentation. During the Expert Panel a question was asked what the biggest thing is that a [...]
Puzzelen met SQL: Crash SQL Investigation
16/1/2008 - 10:53 pm
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 2 comments
door Anton Scheffer en Alex Nuijten
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL
die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in
Nederland.
Deze
puzzel is gebaseerd op het verhaal van Carel-Jan Engel tijdens een AMIS
Query over High Availability. Hij vertelde hoe hij actief was bij het
vliegveld van Dresden in een periode dat [...]
Where is my WHERE?
21/12/2007 - 10:16 am
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 10 comments
Sometimes I encounter query which have a WHERE clause that starts with:
select … from … where 1=1 and …
When asked the reason for this predicate, most of the time (if not all) "Because it’s easy if you want to comment out some of the conditions". Say you have a query that [...]
