Oracle XBRL Extension Ready for Download
The new ready to download Oracle XBRL Extension is a “no cost option” on top of the latest Oracle Database 11.2.0.2.0 release. With this added functionality you will get …
Category: Languages
Oracle 11g SOA Suite read multi record data from csv file with the file adapter (master-detail)
The file adapter is a very powerlful tool to read files with structured data. Most of the time you will read simple csv files with one record per row. …
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
![Querying ISO Country names and codes from SQL – exposing standard domains based on dynamic internet retrieval]({"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"} "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 …
External Views (XML based)
Something new? Eh? Should you do this? Eh? In all, probably not, but for me this was a good exercise towards some more updated demo scripting for my “Boost …
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 …
Extending XML Document Validation with Schematron
The use of XML documents is common practice nowadays and so is XML schema (XSD) to validate XML documents. XML validation is often needed to ensure structure, content and …
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 …
Hotsos 2010 – Presenters, Presentations, Presenting
I never find it very easy to try to capture the atmosphere during a conference, the presenting part, the presentations or the discussions, for example, you could have with …
Hotsos 2010 – About swag, the Oscars and other stuff
Its Sunday and its raining outside. The nice weather on Saturday (approx. sunny / 20 degrees Celsius) has gone. After a decent flight on Friday where I actually made …
Part of the Puzzle: Oracle XMLDB NFS Functionality
This story is long overdue and no its NOT about the Oracle Database 11g Database File System (DBFS). Its about an “undocumented” NFS functionality that, maybe someday, will be …
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. …
Advert: Oracle XMLDB Masterclass in Germany
Here a small advert for one of my events scheduled for this year. On the 24th of Februari I will be giving a Masterclass regarding Oracle XMLDB in Germany. …
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 …