Author: Lucas Jellema
Today I decided to write a small package, an extension, to the Repository Object Browser for Oracle 10g (or 9i) Designer and Oracle 10g SCM. This extension will provide …
Virtual Private Database does not let me go. Today I had another burning question to which I could not see the immediate logical answer. I know that when a …
The question on the OTN Forum was: How do i add rows to a pl/sql table and then use the table to open a ref cursor.. Somehow I was …
Years ago I have read about the package dbms_application_info for the first time. This is a standard supplied package, shipped with every Oracle Database. It can be used to …
A very good instruction on the programmatic interface to Orace’s PL/SQL debug facilities. If you do not happen to have a GUI PL/SQL debugger – such as in JDeveloper …
What happens if the policy function on table A returns a predicate that refers to table B and table B has its own policy. For example: in a Master-Detail …
Does Oracle provide a SELECT trigger in the same way that we have INSERT, UPDATE and DELETE triggers? No, it does not. However. It does offer something that comes …
The 10gR2 or Paris release of Oracle Warehouse Builder is attracting a lot of attention. During Oracle Open World 2005 of course, and in a number of Blogs by …
Rob just asked me if he could easily create break groups in a normal SQL query, somewhat like BREAK ON in SQL*Plus and break groups in Oracle Reports. The …
I noticed in the Oracle 10gR2 New Features Guide a piece on the Rules Manager. I have not yet figured out what it does exactly. But it certainly sounds …
Just read an excellent overview of the new 10gR2 feature of DML Error Logging: 10gR2 New Feature: DML Error Logging by Natalka Roshak on Oracle FAQ’s. It gives a …
Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, …
It is not yet a production release, but hey: who cares when you see what it contains in terms of new functionality. Apart from the UIX design time support …
I just googled across this open source project. It is relatively simple, but can be quite useful. Its demos are at any rate useful, if only for the JavaScript …
Over the past period I have written several articles on AJAX – the Asynchronous JavaScript and XML mechanism for dynamically updating a web-page based on background communication with the …
The problem I am dealing with: downloading all data that is potentially to be displayed in the client – for example in SELECT LISTS – takes too long to …
One of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to …
I just came across an article that very clearly introduces AJAX: An Introduction To Ajax Recently I did an internal presentation Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – …
(this event on JSF and ADF Faces will take place in Nieuwegein, The Netherlands and will be Dutch-spoken. Hence this announcement in Dutch) AMIS Query: Java Server Faces, van …
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
Last week, I had the opportunity to present on the Spring Framework for the Oracle Consulting Java Professional Community at Oracle The Netherlands. Having worked at Oracle for over …
Today one of my colleagues asked me “What again was your query for finding overlaps in a table with periods, demarcated by start_date and end_date. I think he was …
In several previous posts, I have wondered about the potential for combining the ADF Binding Framework and the IDE capabilities around ADF in Oracle 10g JDeveloper with the Spring …
Swinging in the sun, enjoying one of this Summer’s last great days perhaps, I was reading the September/October issue of Oracle Magazine. One the interesting pieces this issue was …
The Repository Reports in the Oracle Designer web-interface Repository Object Browser provide an overview of the most useful properties of the most important components of the elements in the …
The other day, we had a very interesting debate about the role of the database in (our) Java/J2EE projects and architectures. Should you limit the use of the database …
Spring consists of a number of modules, such as the IoC Container, AOP, MVC, Persistence, DAO and Remoting. These modules are relatively losely coupled: some can be used without …
For the on-line documentation for release 10.1.2 of the Oracle Application Server, see http://download-uk.oracle.com/docs/cd/B14099_10/web.htm. It contains besides others links to documentation on the ADF (Application Development Framework), such as …
Today I read this very interesting article by Chris Schalk – responsible for the Web application development features within Oracle JDeveloper- TheServerSide.com – Building Custom JSF UI Components. Chris …
The Repository Object Browser is a valuable web-based interface to the Oracle Designer and SCM Repository, as I discussed in a recent post: Installing the Oracle Designer Web Interface …
One frequently overlooked component of Oracle Designer is its Web Interface: the Repository Object Browser. Added in 2003 to Designer 6i and 9i as well as in 2004 to …
After a year full of stuff like Spring, UIX and ADF, JHeadstart, Struts and JSF, XSL-T and the likes, PL/SQL and SQL, I had a bout of nostalgia this …
I was kindly requested recently to do a brief – and it was stressed several times that it really had to be brief, not something I am particularly well-known …
Today I discovered GreaseMonkey mozdev.org – greasemonkey: home. Greasemonkey is a Firefox extension which lets you to add bits of DHTML (“user scripts”) to any web page to change …
It sounds intriguing. If only I could really get it. IBM has developed software, called UIMA for Unstructured Information Management Architecture, that can be used for analysis of unstructured …
I just read in a Dutch IT magazine (Computable) about the release of Bizgres 0.7. Bizgres is an open source project: The Bizgres Project (www.bizgres.org), a Greenplum-sponsored, community-supported, open …
Interesting thread on Experts Exchange, on how to develop a standard facility to do debugging inside web-pages: JavaScript: How to print log messages to Firefox JavaScript console in my …
The 2005 O’Reilly European Open Source Convention brings together diverse projects and communities from across the continent and around the world to address the changes and challenges unique to …
Hierarchical queries using CONNECT BY logic are discussed quite frequently. Often in terms of EMP, the famous demo table that has a self referencing foreign key – MGR to …
De Autmatisering Gids besteedt deze week aandacht aan de pilot rondom remote werken die sinds eind mei – het AMIS weekend – binnen AMIS loopt. Alle medewerkers hebben een …