OOW 2012: Little things make me happy
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 …
Author: Alex Nuijten
OOW 2012: Is PL/SQL still alive?
![OOW 2012: Is PL/SQL still alive?]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "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 …
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 …
Advert: Dutch preview event ‘Collaborate 12’
March 31, 2012
AMIS, Announce / Events, Database, IT, Oracle, Oracle E-Business Suite, PL/SQL
1 Comment
‘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 …
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, …
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 …
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 …
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 …
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 …
Oracle Open World / Java One Preview bij AMIS
September 8, 2011
AMIS, Announce / Events, Database, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
No Comments
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 …
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> …
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 …
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 …
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 …
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 …
AMIS@OOW
October 7, 2010
AMIS, Data Warehousing & BI, Database, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, XML
No Comments
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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? …
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 …
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 …
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 …
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 …