APEX plugins contributed to the APEX community by AMIS developers
![APEX plugins contributed to the APEX community by AMIS developers]({"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"} "APEX plugins contributed to the APEX community by AMIS developers")
I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have …
Category: PL/SQL
The Talking Database – on putting query results into words – soundbiting from SQL?
In my investigations into the role the Oracle RDBMS can play in application architectures and especially how Java applications can leverage the database, I have ventured into some strange …
Anti-Search patterns – SQL to look for what is NOT there – Part Two
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there. Not the queries in this article (and its prequel): …
Querying ISO Country names and codes from SQL – exposing standard domains based on dynamic internet retrieval
The other day, I came across a press release – www.iso.org/iso/pressrelease.htm?refid=Ref1383 – from the ISO organization, announcing that they had issued new country codes for the islands in the …
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 …
Extreme Decoupling in SQL – Select and DML against a table that is not a table at all
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently mutually dependent agents, we introduce more opportunity for flexibility, …
UKOUG Tech – EBS report
December 19, 2010
Oracle, Oracle Application Development Framework, PL/SQL, Software Development, Tools
1 Comment
Just as ODTUG Kaleidoscope and Oracle Open World, the UKOUG Tech-EBS is a great Oracle oriented conference. It’s held in Birmingham but the speakers and participants come from all …
APEX: Creating a form based on a procedure
Introduction Within ApEx for a while it has been possible to create a page (more specifically, a form) based on a procedure. A procedure enables you to build in …
Dynamic Actions in APEX
After visiting the OPP/APEXPosed conference in Brussels I decided to write a post on how to create a relatively simple dynamic action in APEX. When you are working with …
AS_PDF, generating a PDF-document with some plsql
I’ve written a small package (1500 lines). But with this package you can generate a PDF-document with a few lines of PL/SQL code. It’s small because it lacks some …
PL/SQL (and APEX) highlight of the year: OPP Conference in Brussels, 27-28th October
PL/SQL Developer Tools Session Brussels (Belgium) will be the PL/SQL Hotspot of the world during the two-day OPP 2010 (ODTUG’s Oracle PL/SQL Programming) conference – that is co-located with …
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 …
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns (presentation at OOW 2010)
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas Jellema PL/SQL is a venerable programming language that is both vital and very …
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
September 21, 2010
Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Web HTML5 CSS3
No Comments
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the …
Oracle Advanced Queuing and JMS – bridging from AQ to JMS and vice versa
September 18, 2010
Database, Databases, Java, Oracle, Oracle WebLogic Server, PL/SQL, SOA
No Comments
In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on …
Event based Decoupling in PL/SQL – your first Advanced Queue adventure
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the …
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 …
Parsing a Microsoft Word docx, and unzip zipfiles, with PL/SQL
Some days ago a collegue of mine asked if I could made something for him to unzip a Microsoft Word 2007 docx file. And of course in the database …
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 …
Utl_compress, gzip and zlib
Oracle has a a supplied package utl_compress, which can be used to compress and decompress data with PL/SQL. According to the documentation it uses the “Lempel-Ziv compression algorithme”, and …
Uploading and viewing photo’s with your mobile APEX application
How to upload photographs on you mobile phone with an Apex application? The question was asked to me this morning. At our company we all drive a company car. …
ADF 10g Dynamic Columns: Or how to implement an updatable dynamic table
January 11, 2010
Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Web/Java
3 Comments
Although it is all about ADF 11g these days there are still some challenges in ADF 10g projects that run at some of my customers. Today I finished a …
SOA Suite 11g – Oracle BPEL Master and Detail process coordination using signals
A BPEL process can communicate with another BPEL process just like it can communicatie with any Web Service – as BPEL processes expose WebService interfaces to the world – …
Oracle 11gR2 – alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring (dedicated to Anton)
On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive Suquery Factoring. Instead of using CONNECT BY and its …
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 …
AMIS Query – Verslag van Oracle Open World 2009 – dinsdag 27 oktober (uitnodiging)
October 23, 2009
Database, IT, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA
2 Comments
Vorige week was in San Francisco het hoogtepunt van het Oracle jaar: Oracle Open World 2009, de grootste IT conferentie ter wereld. Tijdens deze conferentie ontvouwde Oracle haar strategie …
SOA & SOA Suite for Oracle Database Professionals – seminars in Perth and Melbourne and Singapore (November 2009)
Next month, I will visit Australia and Singapore to present on SOA and the Oracle SOA Suite – to Oracle database developers. In this one-day-long seminar, I introduce the key …
OOW 2009: The killer feature of Oracle Database 11gR2 – Edition Based Redefinition (or database object versioning)
Today I presented on what is possibly the hottest story on the Oracle Database 11gR2 release: Edition Based Redefinition (EBR). EBR allows us to add a whole new dimension …
Oracle RDBMS 11gR2 – Solving a Sudoku using Recursive Subquery Factoring
Oracle Database 11g Release 2 introduces a new feature called Recursive Subquery Factoring. My collegue Lucas sees it as a substitute for Connect By based hierarchical querying, Oracle RDBMS …
OOW 2009: APEX 4.0 – a source of inspiration
This article is about APEX – some of my initial impressions from the pending (deep into 2010) APEX 4.0 release. And the title is in no way meant …
OOW 2009: Introducing SOA and Oracle SOA Suite 11g for Database Professionals
The Oracle Open World 2009 conference is almost underway. On Monday 12th October I will do two presentations, and I am done preparing the first one of them …
Create XSD from XML instance document – new JDeveloper 11gR1 feature
While looking into the XML functionality in JDeveloper 11g, I came across a feature that was added in the 11.1.1.1.0 release – July 2009: XML Schema from XML Document. Functionality …
Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring
Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous …
UKOUG Conference Series Technology – E-Business Suite 2009
I got a small request from the UKOUG team if I could be so kind to do a little bit of advertising for the UKOUG conference. The first thing …
OPP is coming to Atlanta
I have been invited to deliver two talks on performance at the OPP conference, November 10th and 11th in Atlanta. The topics I will address are Pipelined Table Functions …
Oracle SQL and PL/SQL: juggling with user defined types (ADT) and XMLType – for creating an ADT based XML Service API
Packages in the Oracle Database are a fine construct to use for creating a service API at PL/SQL level – that through JDBC or other connections into the database …
Oracle RDBMS 11gR2 – alter or replace user defined types even when there are dependencies
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this …
Oracle RDBMS 11gR2 – LISTAGG – New aggregation operator for creating (comma) delimited strings
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in …
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 …