Author: Lucas Jellema
BPEL is emerging as the standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. The …
Managing users and privileges on countless folders and application systems, configurations and workareas as is the job of the Repository Administrator can be quite a task. Each privilege on …
An interesting problem we were working on some time ago is the following: a JHeadstart application – release 9.0.4.5 created with UIX, BC4J and Struts, JDeveloper 9.0.3 – has …
Title: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration Authors: Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault Published by: Rampant Tech Press ISBN: …
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
Last Friday we enjoyed one of the special privileges we have in our partnership with Oracle in The Netherlands – we have a private session on one of Oracle’s …
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it …
Last Thursday evening was special. On the occasion of Chris Date’s visit to The Netherlands, the product marketing department of Oracle Netherlands had gathered some 25 odd (could also …
Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is …
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude …
Last week we received another shipment of books for our evergrowing library. Among this shipment were these titles:
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by …
Perhaps SchemaSurf from Cobblesoft – FREEWARE – is worth a little investigation. SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does …
From time to time there is a need in my SQL queries to have access to a table with a specific number of records. Sometimes I want to explode …
Today I was at a customer site where we discussed programming using the API for Oracle Designer and Oracle SCM. I demonstrated the F5 function key in both the …
This post is the sequel to AMIS publishes a ViewObject Copy tool – JDeveloper 10g Extension (plugin) for ADF Business Components that we released last week. That post announced …
OK, it is a fairly trivial task. But when you have to prepare for workshops etc. it may take a lot of time to purge/cleanse/empty all student’s schemas without …
In this post I collect references to interesting articles on a variety of topics – Java, SQL, Business Intelligence, Web Services, HTML/CSS, JavaScript – that I have come across. …
From both the Oracle website as well as Mark Rittman’s weblog the release of Oracle’s new enterprise level Business Intelligence product Enterprise Planning and Budgetting was announced. This tool …
We at AMIS work hard and with great fun at developing high quality applications. We like to use good tools and we like to push those tools to the …
This weekend I installed the Google Desktop Search tool. It is currently in Beta, it is free, about 400K in size and can be downloaded from http://desktop.google.com/. After you …
From today’s customer assignment I extract the following recipe – for BC4J, JSP and Struts.: Suppose that on the FindPage of our JHeadstart generated JSP application we would like …
JBoss just released JBoss AOP 1.0 Final production release. See the announcement on The Server Side – JBoss AOP 1.0. It has a plugin for Eclipse but can be …
Today AMIS announces the immediate availability of the AMIS JHeadstart Application Generator Extensions. A free set of enhancements for JHeadstart 10g (9.0.5.x) that will allow you to generate much …
Yesterday it was an almost nostalgic day. For several years – primarily in the late 1990’s – I was heavily engaged in everything to do with Oracle Designer, its …
Today, AMIS released the JHeadstart 9.0.5.x version of the ALS application for BC4J and JSP/JSTL. Download the zip-file with the entire application, the database setup and the JDeveloper 10g …
Thusfar we have been lucky – or careless – to not have had to consider distributed application deployment. However, web-applications running in the DMZ accessed by internet users directly …
BI Beans only provides export to CSV to be imported into Excel, at least up to the 9.0.4 release: News from the BI Beans product team: In the 9.0.5 …
A topic that seems to come up again and again is the issue of reusing BC4J packages across applications and projects. And along the same lines structuring the BC4J …
Data Mining in PL/SQL applications – Supplied Package DBMS_FREQUENT_ITEMSET (new in 10gR1) Resource: Oracle 10g Supplied Packages – dbms_frequent_itemset. This package exposes some part of the Data Mining capability …
During this week’s JHeadstart workshop it turned out that our recipe for Display Only LOV fields did not support JHeadstart 10g (release 9.0.5.x). I have changed the recipe to …
This brief article by Frank Manno from the Developer Shed describes a pretty, elegant way to create strings that act as hyperlink – where not just the string but …
During the JHeadstart workshop I am teaching this week there as a question: How can I – in a two-column layout – force two adjacent fields to be positioned …
I came across an interesting site: del.icio.us . It describes itself as “a social bookmarks manager. It allows you to easily add sites you like to your personal collection …
Thanks to Mark Rittman’s blog: The Oracle Export File DDL Extract Wizard What Does the DDL Extract Wizard Do? The DDL Extract Wizard will reverse engineer Oracle Export files …
From this thread on The Server Side: HttpUnit 1.6 released. HttpUnit 1.6, the first new production release in over a year, is now available. HttpUnit emulates the relevant portions …
Java and persistence are hot. And continue to be hot. If I read things correctly, Sun – through Linda DeMichiel and Craig Russell Specification Leads, JSR-220 and JSR-243 – …
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 have given the meta-data features in the J2SE 5.0 Tiger Release some more thought. Reading – in this order – through the following articles, I rather quickly had …
All the news etc. starts here: J2SE 5.0 Home For new features see here (new features). and here (release notes). Then there is the article: Java 5.0 in a …
![Parallelizing Table Functions (instead of paralysing)]({"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"} "Parallelizing Table Functions (instead of paralysing)")