Oracle to offer free database
Released on 25th October 2005, Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s …
Author: Lucas Jellema
Submit an Abstract for the ODTUG 2006 Virtual Desktop Conference (deadline 15th November)
Desktop Conference 2006, February 21-23 – ODTUG is once again joining forces with the Business Intelligence and Data Warehouse SIG, and Oracle Corporation in presenting this three-day virtual conference. …
Oracle Designer Check In – synchronize P_VERSION argument
As you can probably tell from the topics and nature of my blog-postings recently, I am very deepy involved in a project using classical Oracle development technology such as …
Introducing new Oracle10g R2 features for Application Development (article in Dutch)
![Introducing new Oracle10g R2 features for Application Development (article in Dutch)]({"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"} "Introducing new Oracle10g R2 features for Application Development (article in Dutch)")
For the Fall 2005 issue of OGh Visie, the magazine of the Dutch Oracle User Group, I have written an article introducing the most enticing new features for Application …
10gR2 New Feature: Asynchronous Commit
Again a very good post on a 10gR2 feature by Natalka Roshak. This time she writes about the Asynchronous Commit in 10gR2. See: 10gR2 New Feature: Asynchronous Commit Asynchronous …
VPD Policy Tester
My VPD policies were causing troubles when I was running the Forms: ORA-28113 Policy Predicate Has Error . I could not easily figure out which Policy it was, as …
Use of TODO tags to quickly generate a tasklist for PL/SQL development
There are quite a few neat tricks we can steal from other technology stacks and communities for use with PL/SQL development. I have recently written an article on AOP …
Dashboard for Oracle Designer – free extension to Repository Object Browser
It can be both quite useful and rather difficult to monitor the events taking place in Oracle Designer and/or Oracle SCM (Software Configuration Manager). Keeping track of all Check …
Apache Geronimo 1.0-M5 Released : Certified J2EE 1.4 Server
At some point during the last year I had gotten the impression that Geronimo was dead. It had missed its scheduled release date – and no new date or …
PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving
Source code control for PL/SQL is often discussed in the organizations that I encounter. The database itself will always hold the latest version of the PL/SQL objects we are …
PL/SQL post compiler to fix TAPI – dealing with the 'TAPI cannot deal with MERGE' problem
Recently I wrote a post about the failure of the TAPI (table API) generated by Oracle Designer to work together with Merge operations: Designer TAPI triggers fail on SQL …
Shipment of books – September/October 2005
The latest shipment of books – just arrived today – contains among others: Writing Effective Use Cases (Paperback) by Alistair CockburnPublisher: Addison-Wesley Professional; 1st edition (January 15, 2000); ISBN: …
Assasination attempt on MySQL? – Oracle Announces the Acquisition of Open Source Software Company, Innobase
Interesting news on Friday: the Oracle acquisition – the eleventh this year – of Innobase. Innobase? You may very well have never heard of it. Unless you are a …
Designer TAPI triggers fail on SQL MERGE operations
It turns out that the combination of the Table API (TAPI) as generated by Oracle Designer and MERGE operations using the Oracle 9i SQL Merge statement are not compatible. …
View to select CG$ERRORS from (easing RuleFrame pain using a Table Function)
On my current project I am doing a lot of work with CDM RuleFrame and the Oracle Designer Table API. I just learned that the TAPI cannot survive MERGE …
Poor man's VPD – Virtual Private Database before 8i and in Standard Edition Databases
The concept of Virtual Private Database – aka Row Level Security or Fine Grained Access Control – is quite powerful. Without any impact on the SQL used in the …
Death of the End Date – How LAG and LEAD help fight redundancy
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Summary results for all dates, including the ones that I do not have data for – example of using Partition Outer Join – Oracle10g SQL Feature
Trying to make myself useful by answering some of the questions on the OTN SQL and PL/SQL Forum, I came across this question: Group Above Report problem…not able to …
Oracle Designer and Oracle SCM – Last Date Modified and querying in the ROB
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 …
Another Pop-Quiz: Whose VPD policy is used when executing SQL in a (definer rights) package?
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 …
Returning a Ref Cursor based on a PL/SQL Collection
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 …
Good Citizenship – Have Client Applications register themselves with the database
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 …
Debugging PL/SQL with DBMS_DEBUG
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 …
Pop-quiz: VPD policy that depends on a table with a policy…
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 …
Select Trigger in Oracle Database – introducing Fine Grained Auditing
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 …
Data Profiling with Oracle Warehouse Builder 10gR2 (article in Dutch)
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 …
SQL*Plus or Report style Break Groups in SQL Query
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 …
Oracle 10gR2 – New Feature: the Rules Manager
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 …
10gR2 New Feature: DML Error Logging
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 …
Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)
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, …
Oracle JDeveloper 10.1.3 EA1 New Features
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 …
AJAX Tag Library – Open Source project for easy use of AJAX mechanisms from JSPs
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 …
Enhancing PHP-based WordPress Weblog with AJAX driven enrichments
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 …
Increasing speed of making data available in the web-page – on AJAX, controlling data caching and JavaScript Libraries
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 …
Building Check In protection into Oracle Designer/Oracle SCM – Check In only by the user that did the Check Out
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 …
An Introduction To Ajax – great article on dev2dev
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 – …
AMIS Query – donderdag 29 september 2005 – Java Server Faces en ADF Faces, van vergezicht tot standaard View technologie
(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 …
Standard for Database Development – Getting rid of USER from PL/SQL and SQL – no longer is USER equivalent to End User
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 …
Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting
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 …
SQL Question: Find overlap in periods – using Analytical Functions (LAG and LEAD)
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 …