Author: Lucas Jellema
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 …
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 …