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 10pm a lot of information was presented by several AMIS colleagues. My contribution to the evening was (amongst others) a little […]
Alex Nuijten
OOW 2012: Is PL/SQL still alive?
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 the Oracle 12c database the enhancements were broken into three areas: Improved PL/SQL and SQL interoperability In the current version of […]
OOW 2012: My Schedule
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 many good session available. I thought I’d share my schedule, it might inspire you for your own schedule (or makes it […]
Advert: Dutch preview event ‘Collaborate 12’
‘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 evenement om bij te zijn wanneer je geïnteresseerd bent niet alleen in Oracle Applications (E-Business Suite, JD Edwards, Siebel, etc.) maar […]
Looking back at UKOUG 2011
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, I already knew that it is a big conference. Lots of great speakers and a very good agenda. On the agenda […]
APEX: Make a report row clickable
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 the icon this navigation will take place. For the current project, this was not what they wanted. They wanted to click […]
It’s here: Oracle Public Cloud
just so you know…
Oracle Open World 2011: Oracle Database 11g Features for Developers by Connor McDonald
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 in 2005. Everybody I talk to who attended a session by Connor – ever – is always very positive on his […]
Oracle Open World 2011; Unstructured Data and Multimedia SIG
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 data, and it will only increase in the future. The number of images and videos will only increase in the future. […]
Where am I, and what am I doing… Oracle Open World 2011
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 rest of this post is basically just my schedule for the upcoming week in San Francisco. Really looking forward to all […]
Oracle Open World / Java One Preview bij AMIS
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 aanwezig te zijn als spreker op Oracle Open World zullen hun presentaties geven in Nieuwegein. AMIS-ers Lucas Jellema, Alex Nuijten, Peter […]
Business Rule: Only One per Day, but keep the time
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> create table test 2 (id number 3 ,inspection_dt date 4 ); Wouldn’t it be nice if it was possible to do […]
ODTUG KScope 2011: looking back
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 sessions and the wealth of information that you get is really quite extraordinary. In this blogpost I will highlight some of […]
ODTUG KScope Preview 2011
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 in Longbeach, California van 26 tot en met 30 juni. Het is niet voor iedereen weggelegd om daar naar toe te […]
Should you expose a Stored Procedure via XMLType?
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 I will use a Package containing two functions, the signature of the package is as follows: create or replace package emps_pkg […]
Creating an XMLType based on Object Types
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 Mediator. There are several options to create an XMLType. In this blogpost I will show you two ways of doing this. […]
AMIS@OOW
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 employees were at Oracle Open World, and each one covered one area of interest. Before dinner Lucas gave an overview of […]
Looking back at ODTUG Kaleidoscope 2010
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 I consider, the highlights of this event. I always enjoy going to this conference, it’s nice to see old friends and […]
ODTUG Preview: mini conferentie (APEX, Database en SOA)
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 jaar vanaf 27 juni in Washington DC. Deze conferentie trekt van oudsher veel Nederlandse deelnemers, waaronder een flinke afvaardiging van AMIS. […]
Sneak Peek and what can come of it
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 […]
DELETE in the MERGE statement
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 […]
My ODTUG Kaleidoscope 2009
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 […]
Business Rule: Only One Clerk per Department – 11g Style
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 […]
Subquery Factoring in Oracle 11g
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”. […]
Referential Integrity with Virtual Columns, the Sequel
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 […]
Referential Integrity with Virtual Columns
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 […]
Instrumentation
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 […]
Puzzelen met SQL: Crash SQL Investigation
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 […]
Where is my WHERE?
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 […]
Puzzelen met SQL – de Kassabon
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 einde van het jaar wordt het op de kleintjes letten. Een groot deel van je budget gaat op aan Sinterklaas- en […]
For Lovers only,… of the PL/SQL kind I mean
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 always mentions to contact Brynn Llewellyn if you have ideas on how to improve the PL/SQL language.
CTAS on a Table with Nested Tables
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 do some experiments with it and didn’t want to mess with the original table. A simple CTAS (Create Table As Select) […]
Implementation Restricted Relaxed in Oracle 11g
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 of records While I was playing around on our Oracle 11g database, I found that this restriction was lifted. How cool […]
DBMS_PROFILER Report for SQL Developer
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 on DBMS_PROFILER built in package isn’t there. DBMS_PROFILER allows developers to profile the run-time behaviour of PL/SQL code, making it easier […]
Puzzelen met SQL – De Ideale Televisieavond van Madelon
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 alle scripts worden gedownload, zowel de DDL en data-load scripts, als scripts met mogelijke oplossingen. Ook bevat dit on-line artikel enkele […]
How to test for DBMS_OUTPUT with Quest Code Tester
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? No, I don’t think so, but it is the most common way. Steven Feuerstein created Code Tester, and if you are […]
ODTUG Kaleidoscope: HOTSOS Instrumentation Library for Oracle
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 so that’s why I am writing this Blog now. One of the sessions I really enjoyed was given by Eric Evans […]
CTAS and IOT
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 entry so I won’t forget…. or at least that I will know where to look. create table [table_name]( [col1] primary key, […]
Contract-Oriented PL/SQL Coding
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 of Contract-Oriented PL/SQL coding as suggested by John Beresniewicz, who did this presentation.
Looking back at the OPP Conference: Steven's Keynote
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 thing that comes to mind is the keynote given by Steven Feuerstein, titled "Wake up and Smell the …". In this […]