Author: Alex Nuijten

Yesterday evening we had the annual “We went to OOW and this is what’s new in the world we call Oracle” at AMIS. Starting around 5pm and ending around …

Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”. The room was packed. For the upcoming release of …

This will be my third time attending Oracle Open World and I’m really looking forward to the event. It is very hard to make a schedule, there are so …

‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét …

Now that the UKOUG annual conference in Birmingham is over, it’s time to write my thoughts down. As this was the second time that I attended the UKOUG conference, …

When you create a “Report with Form”, there will be an icon in the report which allows you to navigate to  the form page. Only when the user clicks …

just so you know…

Yesterday I had the pleasure of attending a session by Connor McDonald. I heard a lot about him, his presentation style, and I even did a book review back …

Oracle Open World is underway. My first session, which I didn’t plan, was on Unstructured Data. There is a lot of unstructured data going around, as opposed to relational …

This post is more for me than it is for you, at least I will have a place to quickly check where am I supposed to be going next.The …

Op maandag 19 september zal er bij AMIS een Oracle Open World Preview sessie worden gehouden. Een groot deel van de Nederlanders die het dit jaar gelukt is om …

The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) SQL> …

Last week the yearly ODTUG KScope conference took place in Long Beach, California. I always need to time to let this wonderful event really sink in. The number of …

Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats …

When you want to expose your Stored Procedure to the “outside world”, should you do this using XMLType? As always, the correct answer is “it depends”. For this example …

Sometimes it is necessary to create a Stored Procedure which returns an XMLType, like when you want to expose the Stored Procedure to the “outside world”, like via a …

Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS …

In case you missed it (how is that possible?) last week was the annual ODTUG conference, Kaleidoscope in Washington DC. In this post I will share some of, what …

Voor het vierde achtereenvolgende jaar organiseert AMIS de “ODTUG Preview” sessie op 8 juni 2010 bij AMIS in Nieuwegein. ODTUG Kaleidoscope 2010 is een conferentie voor Oracle ontwikkelaars, dit …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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.     Vooral op het …

I just came across this website "I love PL/SQL, and…", one of Steven Feuerstein’s website. If you ever attended a seminar given by Steven, you already know that he …

The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to …

If you are a regular user of the FORALL statement, you are probably also familiar with this message:   PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table …

Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based …

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. In dit on-line artikel kunnen …

What is the most common way of testing PL/SQL code? I think it is using DBMS_OUTPUT and manually verifying the results. Is it the best way of testing code? …

Last week six of us at AMIS attended the ODTUG Kaleidoscope conference in Daytona Beach, FL. I always need some time to digest all the information that was presented …

This was the second time I needed to look up how to create an Index Organized Table (IOT) with a Create Table As Select (CTAS). So just a quick …

During the Oracle PL/SQL Programming Conference in San Francisco another session I really liked was called "Contract-oriented PL/SQL Coding". In this blog I will go over the basic principles …

Now that the OPP is over, it is time to look back on the most interesting things that I have heard for the last couple of days. The first …