New Book Shipment is in – recent titles on Web, Java and Oracle
Our monthly book-shipment just arrived and I am playing Santa Claus right now by handing out books to some eager colleagues. The list of titles we received this month …
Category: Oracle
Map Adventures with Google, Oracle and Spring
In summer 2000 I started in the Field Service development team of Oracle’s eBusiness Suite (http://www.oracle.com/applications/service/srvonl_cont.html). The web form Dispatch Center contains four Java applets. One of them is …
Wrong use of constant packages
On my recent project we have a large package holding constants values. From a design point of view this is a very elegant solution because this way the constants …
Publishing Data Manipulation as an RSS Feed – using Oracle MOD_PLSQL and Flashback
Events in the database – such as Data Manipulation or DML, Database Object Manipulation or DDL, session connect and disconnect, database startup and shutdown, a user querying for specific …
Smart denormalization and Enhanced PL/SQL Function Call performance – Comparing Function Based Index and Materialized Views
Queries that contain calls to user defined PL/SQL Functions can be performance killers. If a function call is part of the WHERE clause, depending on the execution plan it …
Oracle Enterprise Service Bus (ESB) – A First Impression (and it's not bad at all!)
You never get a second chance for a first impression, the shampoo ad warns us. So every software vendor is likely to be a little nervous about showing a …
Pivot dynamic data with pipelined function
Many people want to pivot the result of their queries. I have no idea why, but they do. For instance,
JavaOne 2006 has started – get the hand-outs for the presentations now
Even when you are not in San Fransisco right now, JavaOne2006 will be on your mind somehow. Or if it is not, as a Java Developer it probably should …
ESB – the new Oracle InterConnect
Today I attended a very nice workshop at Oracle Netherlands where some Oracle Partners could get acquainted with the beta 10.1.3 release of the Oracle Enterprise Service Bus (ESB).
Oracle Toplink goes open source – launch of the Community Edition
I just noticed the Toplink Essentials JPA (java Persistence API or EJB 3.0 Persistence) homepage on OTN: http://www.oracle.com/technology/products/ias/toplink/jpa/index.html . As you probably already know, Oracle has open sourced a …
Installing Oracle Grid Control 10 release 2 on SuSE 9.3 ES
With all those fancy plug-ins for Microsoft tools release 2 of Oracle Grid Control 10g seems to be a must-have. However, according to many postings on the internet, installation …
Oracle Lite Part 3 – Our Concise Survival Kit
Introduction Last August and November my colleague Andre posted some entries right here on Oracle Lite. Where he mainly focussed on installation issues I would like to proceed with …
It's a Chameleon! About JSF Pages that change their appearance mid-flight (or: programmatic manipulation of JSF UI Components)
One of the features in Java Server Faces that distinguishes it from for example JSP technology, is the ability to access UI Components programmatically, at run-time. This makes it …
Workshop on EJB 3.0 Persistence – Download Resources
Yesterday we had a very enjoyable and I think interesting workshop on EJB 3.0 Persistence. After a very nice dinner on our terrace – it was lovely weather – …
Recent changes in the EJB 3.0 Persistence specification (that invalidated my code)
While preparing for a workshop on the EJB 3.0 Persistence API that I will present later today, I decided – against all the instructions in demo-school and presentation-college – …
Oracle releases the UIX to ADF Faces migration utility
It was promised and now it has been delivered: The Oracle UIX 2.2 Migration Tool allows you to migrate a project built using Oracle ADF UIX to use Oracle …
Generating PDFs from ADF Business Components View Object datasets using XSQL
In the projects we do, we very often encounter the requirement for generating PDF documents containing data or reports from a database. We usually meet this requirement by creating …
Identifying Duplicates: Traditional vs. Analytical.
While preparing my paper for ODTUG, “One Analytic Function can do more than a 1000 lines of code” I stated that you should be careful not to get carried …
Joyful Successor to Forms – Introduction to JSF (Java Server Faces) and ADF Faces
May 4, 2006
Java, Oracle, Oracle WebLogic Server, PL/SQL, Tools, Web HTML5 CSS3, Web/Java
4 Comments
Developing Web Applications using Java/J2EE technology has not been a picnic over the last few years. It was often hard work, complex, not very productive and the results were …
Integrate webforms application with InterConnect and BPEL
In the last months we have been busy building and extending a webforms application (10g rel 2) to integrate with Oracle InterConnect. The webforms application is a home-build application …
On returning a collection of user defined objects from PL/SQL to Java – shortcut using a sys_refcursor
Oracle 8.0 introduced Objects into the Oracle database, back in 1996. There has been a lot of ridicule for the OO features in the Oracle database, some of it …
SELECT * FROM RSS_FEED – querying feeds in SQL using Table Functions and XML parsing
In a recent article – Building an RSS Feed Reader in PL/SQL – using dbms_xmlparser, dbms_xmldom and dbms_xslprocessor for parsing and transforming – I discussed how we can create …
Building an RSS Feed Reader in PL/SQL – using dbms_xmlparser, dbms_xmldom and dbms_xslprocessor for parsing and transforming
This article will demonstrate how we can build an RSS Feed Reader in PL/SQL. We will use DBMS_XMLPARSER to read an RSS feed from an URL and parsethe RSS …
KC SDPL – Jonathan Lewis
Eindelijk zijn ze er dan. De presentaties over het Seminar van Jonathan Lewis. In dit zip-file zitten de presentaties die Anton en Alex gedaan hebben. Ook zitten de demo-scripts …
The Next Value – How much higher is my salary than the next in (Dense) Rank – Oracle Analytical Functions
It is not terribly important. But since I found the solution, I thought I’d share it with you anyway. During our Oracle 7Up workshop on SQL last week we …
BPEL Project by Oracle and IBM – Open Source Eclipse BPEL Plugin
My first experience with BPEL was late 2004 using the Oracle BPEL PM and Designer plugin for Eclipse. Afterwards, I have worked primarily with the Oracle JDeveloper BPEL Designer …
Find the number of descendant nodes in a SQL query – how many employees work (indirectly) for me? And what do they earn on average?
Every once in a while you run into a SQL challenge that seems extremely simple at first glance and turns out to be not so very simple when you …
Cost Based Optimizing through time travel? – the value of meta-data for enabling Query Rewrite
Query Rewrite is an increasingly more important feature of the Oracle database. Linked intimately to Materialized Views, Query Rewrite is used by the CBO to make queries leverage intermediate …
Oracle and resilvering on AIX
Oracle and resilvering data on Mirrored Logical Volumes on AIX How to set up your storage with regards to Mirror Write Consistency Suppose you have or plan to implement an …
JDeveloper, not just for development…
When you startup JDeveloper, default it gives you a “Tip of the day”. I always enjoy reading these tips and I would like to share this one with you:
Aggregating in SQL across multiple levels and along several dimensions using ROLLUP and GROUPING SETS
In preparation for the Oracle 7Up Workshop as well as the Oracle Quiz – The Water is Still Burning (presentation and paper) with Alex for the ODTUG 2006 conference …
Hiding the Web.show_document URL
![Hiding the Web.show_document URL]({"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"} "Hiding the Web.show_document URL")
Last week I delivered a Forms module which invoked the Oracle Reports server by submitting report requests displaying the report on the screen using the Web.Show_document procedure. One thing …
Oracle 7Up to 10g – How time flies… Training for seasoned Oracle SQL and PL/SQL Developers
With the advent of the Oracle 7 RDBMS – 1993 – a new era dawned. Many of the key database functions and facilities, such as (Enforced) Integrity Constraints, Stored …
JBoss to be acquired by Red Hat – The Oracle (Red) Heat is off
Yesterday it was announded by JBoss that it signed an agreement to be acquired by Red Hat. See the announcement at www.jboss.org. After several months of rumours about a …
SOA and Email in action – Starting a BPEL process instance by sending an email with XML content- on decoupled interaction between web-site and back office
In what is to become a series of articles illustrating a full blown business case for a Conference Registration Processing process implemented using Oracle BPEL PM, this is the …
Implementing a stand alone Email Server – Getting Started with Apache James
Using email as a decoupled integration mechanism for applications is a fairly crude and simplistic yet effective approach. Messaging infrastructures – MOM – were all the rage, and still …
Generic Service – HTML Form Post to Email Servlet
This article is about a generic service that takes a simple HTML Form Post and turns it into an Email. It is not revolutionary – but useful nevertheless. Besides, …
Construct a "Save" URL syntax for the Oracle Reports Server
For a customer had to create an Oracle Forms functionality which would need to make several requests to the Oracle Report Server. The customer wanted me to generate a …
Friday afternoon – updating Oracle XE
I had nothing really to do this afternoon, so i updated Oracle XE (10.2.0.1 Beta) with the Oracle (standard database) patch 10.2.0.2, that is...only the data dictionary part. Just …
PL/PDF
In this blog, Steven Feuerstein writes about PL/PDF, a pl/sql library to generate PDF files. Sounds very interesting. It seems very easy to use, as is shown by an …