UKOUG Conference Series Technology – E-Business Suite 2009
![UKOUG Conference Series Technology – E-Business Suite 2009]({"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"} "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 …
Category: Languages
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 RDBMS 11gR2 – XML Data Partitioning – Part 1
There is a Metalink note (563802.1) that has a very good example how XML data storage, partitioning can be achieved in Oracle version 9.2.0.3.0 (the first officially supported …
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 …
Dutch Oracle Open World Preview 2009
"Almost" Oracle Open World again… AMIS, represented via Peter Ebell, Lucas Jellema and me (Marco Gralike), entered several abstracts for this years Oracle Open World Conference. Probably to our …
Report from presentation ‘JPA 2.0 – What’s new’
July 15, 2009
AMIS, IT, Java, PL/SQL, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java
No Comments
The Java Specification Request 317 (JSR-317) aka JavaTM Persistence 2.0, (JPA 2.0) has finally reached the last stage, “Completion of Reference Implementation (RI) and Technology Compatibility Kit (TCK)”, before …
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 …
Reaching Milestones – some Analytical SQL-etics
Last week, this weblog hit the 9M post reads mark. Since we started technology.amis.nl/blog in July 2004, it took us some 5 years to get to that point. …
Oracle Enhances XBRL Reporting Capabilities with UBmatrix, Inc.
June 27, 2009
AMIS, Architecture, Database, DBA Oracle, Development Tools, Oracle, Oracle E-Business Suite, XML
No Comments
Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others): "To help publicly held companies facilitate the preparation, publishing and …
Enhancing fast queries using "Tapio-Indexes"
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these …
"Hotsos Revisited", Revisited…
May 19, 2009
AMIS, Book reviews and Publications, Databases, DBA Oracle, IT, Oracle, PL/SQL, Software Development
1 Comment
Lucas already gave a very good in depth overview of the "Hotsos Revisited" session last night. It always amazes me how fast he can make a cool blog post …
Bloom Filters, Hierarchical Profiling, Synopses & One pass distinct sampling, jumping the GAPP … – feast for DBAs (considered harmful..)
May 18, 2009
Database, Databases, DBA Oracle, IT, Java, Oracle, PL/SQL, Software Engineering
No Comments
It’s Monday night and a select company of DBAs and Database developers have gathered at AMIS HQ in Nieuwegein for the ‘Looking Back at Hotsos 2009’ session. It …
ADF 11g – Invoke a Popup from a Popup
May 18, 2009
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Web/Java
9 Comments
Today I was triggered by a question on the JDeveloper forum about invoking a popup from a backing bean. Actually some time ago I had to build that solution …
Oracle database directory listing with ls function
Say, you are in need of a directory listing from within the Oracle database similar to the one generated with Unix command ls. Your database doesn’t contain a JVM, …
SQL Inside Out – Challenging Puzzles and Puzzling Challenges – Seminar 22nd April, Sweden
April is the month of the presentations and seminars for me (May and June too by the way). On Wednesday April 22nd, I will be presenting a seminar …
Tag Cloud analysis in SQL and PL/SQL – Using Collections, Table Operator, Multiset and Collect operator
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database level of tags that have been associated with database …
Logging in JDeveloper 11g / WebLogic Server
February 17, 2009
Java, Oracle, Oracle Application Development Framework, PL/SQL, Software Development, Tools, Web HTML5 CSS3
4 Comments
When developing an application it makes sense to add logging to this application. The Apache Commons Logging is a way to implement logging to your application independent of the …
OGH Oracle Ace Cases with…Marco Gralike
An advert for myself. Wow! How cool is that… The local Oracle User Group Holland starts on the 16th of April with a new series of presentations …
Unwrapping 10G wrapped PL/SQL
Many people have tried to unwrap wrapped PL/SQL. Most people haven’t succeeded in doing it, but since Pete Finnegan’s presentation on the 2006 Black Hat conference, http://www.blackhat.com/presentations/bh-usa-06/BH-US-06-Finnigan.pdf, unwrapping …
SOA Suite 11g (TP4) – Create Mediator based SCA Composite Application from XSD – write to output file using File Adapter
A quick overview of you can create an SCA Composite Application that publishes a WebService interface, accepts SOAP Messages and write their contents to a file, appending a …
Oracle Database Cross Session Data Cache – Introducing the Globally Accessible Database Context
An Application Context in the Oracle Database is a name in-memory collection of key-value pairs. Applications can store values in an Application Context – using a package associated with …
(Dutch) Dinsdag 20 januari 2009: PL/SQL Potpourri
Aanstaande dinsdag 20 januari 2009 van 16:30 tot 20:30 ben je van harte uitgenodigd bij de PL/SQL Potpourri. Een kennissessie waarbij acht AMIS-consultants in negen korte presentaties iets zullen …
Oracle Workflow, a brief introduction – Part 2 Building a simple workflow
December 24, 2008
AMIS, Architecture, Database, Development Tools, IT, Oracle E-Business Suite, PL/SQL, Software Development
2 Comments
In this blog I will show you how easy it is to build a process with Oracle Workflow. This demo consist of an automatic step (plsql function) and …
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 …
Code refactoring…
Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer. I am trying the same things in PL/SQL Developer to see if …
Extending the SQL Developer functionality in JDeveloper 11g
One thing that always draws me in tools, libraries and frameworks: what are the hooks, the backdoors, the extension points, the APIs, the event listener registration facilities etc. Today …
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 …
Dynamic and Conditional grouping in SQL queries – for flexible results from single query (oh and a useful case for the CUBE operator)
My challenge of the day: a query that returns aggregate values. And that can be manipulated dynamically to sometimes aggregate grouped by one dimension, sometimes along multiple or …
Investigation into the true parallellism of the Oracle BPEL PM Flow activity in 11g (Technical Preview 4) – on flow, sequence, wait and (a)synchronous calls
The Flow activity is used to configure parallel activity in BPEL processes. In theory, activities contained in two or more branches (sequence containers) inside a Flow activity are …
KC: PL/SQL Developer
Yesterday evening we had a nice, interactive, session about PL/SQL Developer. Theo Tol (BI4U) came by to tell us more about the tool and how it can be used. …
Simple Event Processing – Using SQL with Analytical Functions to detect traffic patterns
One of the intriguing subjects at last weeks Oracle Open World conference for me was Complex Event Processing. The ability to process streams of real time events, and up …
The AMIS team reports from Oracle Open World – big and small announcements, guidance and tips
October 4, 2008
Database, IT, Oracle, Oracle Application Development Framework, Oracle E-Business Suite, Oracle WebLogic Server, PL/SQL, SOA
2 Comments
Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle …
The "X" Product – An X(ML) Database Opportunity?
October 1, 2008
Architecture, Data Warehousing & BI, Database, DBA Oracle, IT, Oracle, XML
2 Comments
“Exadata – Extreme Performance Warehousing“, that’s how the presentation on the last Friday morning from Oracle Open World started (Orig. Presentation Title was “Oracle’s New Database Accelerator: Query Processing …
Oracle Workflow, a brief introduction – Part 1 Setting up an environment
October 1, 2008
Architecture, Database, DBA Oracle, Development Tools, IT, Oracle E-Business Suite, PL/SQL, Software Development
1 Comment
Maybe the following question will arise after reading the title: Oracle Workflow isn’t that obsolete technology? The answer can be very short: Yes it is. (Read the SOD on …
(Dutch) Woensdag 8 oktober: KC PL/SQL Developer onder de loep (met spreker Theo Tol)
In het midden van de 90-er jaren waren er heel weinig en vrij beperkte ontwikkeltools beschikbaar voor het ontwikkelen van PL/SQL. Tegenwoordig is dat heel anders en zijn er …
OOW Presentation: Optimal Use of Oracle Database 10g and Oracle Database 11g for Modern Application Development
I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best …
Using Regular Expressions in Check Constraint – no more articles on Obama, McCain, Palin or Biden
Recently I was working on an RSS feed aggregator – a SQL Merge statement that through the use of httpuritype and XMLTable scans multiple RSS feeds and merges the …