Author: Lucas Jellema
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
I will attempt to introduce analytical functions in a step-by-step manner. A first step into Analytical country could be the following, starting from a very simple aggregation query, exploring …
This tip comes from a very interesting paper by John Flack. It is titled MVC Development in PL/SQL and appeared in the August issue of the ODTUG Technical Journal …
In this post I will tell you about some of the sessions notably on Struts support in JDeveloper, Java/JDBC support with Oracle 10g and the Data Guard option of …
During the Amsterdam stage of the Oracle Open World Tour, I had a great opportunity to interview John Wookey Senior Vice President, Applications Development at Oracle Corporation. John is …
Probably many of you have at least a vague notion of what BPEL (Business Process Execution Language) is all about. Now, thanks to a very good presentation by Oracle’s …
Yesterday, we had another AMIS Query session titled The Future of Oracle Designer. It discussed the future of Oracle development tools, more specifically Oracle Designer and Forms as well …
During our session on the Future of Oracle Designer yesterday I had a conversation with Josef Megens of Oracle Consulting and told me of a trick conceived by Mark …
In this post I will discuss some thoughts I have on the further development of CDM RuleFrame (the Framework for implementing Business Rules). It seems to me that a) …
Recently, IBM announced the open-sourcing of their Cloudscape database. a lightweight, Java-based relational database with a footprint of just 2MB. It’s significantly less resource-intensive than enterprise databases like IBM’s …
Yesterday we had an excellent meeting on Java persistency frameworks, in particular Toplink. Oracle Consultant and Java expert Peter Ebell presented on his experiences with Toplink on a very …
I found a very interesting document (300 pages) with standards on Java/J2EE guidelines, Technical Paper: Java – J2EE Conventions and Guidelines Release 1.0.2 Stephan Janssen The JCS Team (2004). …
At 21st July 2004, release 0.8.2 of the PLDoc open source project for generating JavaDoc style documentation for PL/SQL Code (and now also Tables and Views) was published. PLDoc …
Yesterday we (Hans, Harm, Rob, Wiene and myself) had a session with the Oracle JHeadstart team (Steven and Peter) where they demonstrated the upcoming ADF JHeadstart release. We also …
This post describes some of my recent experiences in using JSP and JSTL. For many probably highly trivial.
An interesting article on java.net on AppFuse: AppFuse: Start Your J2EE Web Apps by Matt Raible. AppFuse tries to make it as simple as possible to build, test, and …
An interesting article appeared on OTN today: ANT 1.6 for Taskwriters. This article will show you that Ant 1.6 has also changed internally and how you can take advantage …
This post describes a list of JHeadstart Application Generator enhancements and also provides a progress report on the implementation of the features mentioned
It does not come as a great surprise, yet I feel sad. Oracle’s Statement of Direction on Oracle SCM declares the product ‘dead as a dodo’. Well, not quite. …
This post – or rather its comments – contain some investigations into the Designer 9i/10g Meta Model and Meta Meta Model. That is: the tables that contain the definitions …
Automated Quality Audit or Standards Enforcement There is a number of tools available for automated standards checking. These tools parse Java source code and determine which standards have been …
Yesterday I started research into the current state of affairs with regard to coding standards for J2EE development. We are looking for an up to date set of low …
Steve Muench published his ADF version of the Toystore Demo: see http://otn.oracle.com/products/jdev/collateral/papers/10g/adftoystore.html. I have not yet tried it out but it should be a comprehensive example of using ADF …
On Tuesday we had a very good session with the Knowledge Center for Web & Java on ANT, the Jakarta “make”-tool. We started with the usual roundup of everyones …
Oracle Data Cartridge is a technology component, part of the Oracle RDBMS (ever since the 8i release), that allows developers to extend the functionality of the database. One area …
During one of Steven Feuerstein’s presentations at the ODTUG 2004 conference, he demonstrated his new tool call QNXO (pka SWYG). This tool promises higher quality, higher producvity for PL/SQL …
![Trick for multiple and flexible parameter passing with MOD_PLSQL and Web PL/SQL toolkit]({"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"} "Trick for multiple and flexible parameter passing with MOD_PLSQL and Web PL/SQL toolkit")