Weblog for the AMIS Technology corner
Alex Nuijten
This user hasn't shared any biographical information
Posts by Alex Nuijten
Should you expose a Stored Procedure via XMLType?
23/12/2010 - 12:34 pm
Posted in Database, Devel. + PL/SQL tools, Oracle, Oracle Development Tools, SOA & Oracle Fusion Middleware | 2 comments
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
is
function get_department_xml (p_department_no in [...]
Creating an XMLType based on Object Types
23/12/2010 - 12:33 pm
Posted in Database, Devel. + PL/SQL tools, Oracle, Oracle Development Tools, SOA & Oracle Fusion Middleware, XML | 4 comments
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. First the “regular” way using [...]
AMIS@OOW
7/10/2010 - 10:30 am
Tags: adf, Database, Java, oracle open world, plsql, soa, XML
Posted in ADF & JHeadstart, AMIS, Data Warehousing & BI, Database, Devel. + PL/SQL tools, Java, JEE, OAS and WebLogic Server, Oracle, SOA & Oracle Fusion Middleware, 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 employees were at Oracle Open World, and each one covered one area of interest.
Before dinner Lucas gave an overview of the trends and topics that were [...]
Looking back at ODTUG Kaleidoscope 2010
5/7/2010 - 2:30 pm
Posted in Database, Devel. + PL/SQL tools, Oracle, Oracle Development Tools | No comments
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 make some new ones.
ODTUG Preview: mini conferentie (APEX, Database en SOA)
18/5/2010 - 2:06 pm
Posted in DBA, Database, Devel. + PL/SQL tools, Oracle, Oracle Development Tools, SOA & Oracle Fusion Middleware, XML | No comments
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. Tijdens de ODTUG Preview sessie [...]
Sneak Peek and what can come of it
26/10/2009 - 3:00 pm
Posted in Database, Devel. + PL/SQL tools, General, Oracle, Oracle Development Tools | 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, Oracle, Oracle Development Tools | 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, Oracle, Oracle Development Tools | 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, Oracle, Oracle Development Tools | 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, 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 [...]
