Category: Database
Yesterday I published an article on this blog describing an approach to sorting the elements in PL/SQL Collections:Sorting PL/SQL Collections, the hard way, the intermediate way and the quite …
Bubble Sort, Quick Sort, Insertion Sort, Shuttle Sort… When time is short, these are not the easiest ways of implementing sort operations on your PL/SQL Collections. In this brief …
While the Java – and even the .NET, Ruby, Perl, Python, PHP – arena is teeming with open source projects and reusable components, the PL/SQL scene is quiet. Why …
In my previous post about package constants I mentioned the application I am working on right now. They gave me the task to speed up the application since performance …
I have a colleague who has a stroke of genius. He can create things in SQL and PL/SQL that I find very hard to fathom, let alone could have …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 – …
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 …
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 …
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 …
Do you still think the only way to retrieve data from the database is to use the java.sql.ResultSet? Try the new (hum) javax.sql.RowSet. One of the coolest features is …
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 …
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 …
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 …
Many people have a dislike of Dbms_job. Setting the right parameters requires good knowledge of the input parameters and you probably need a calculator too! In Oracle 10g, a …
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 …
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 …
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 …
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 …
… well, at least than I thought. Specifying default values for columns in our database tables seems like a pretty simple and straightforward task. The default is either a …
We had some nice KC-DBA (expertise meetings) meetings in 2005. One of them was about virtual machines (VMware basically). To show how you could use virtual machine technology to …
The standard PL/SQL package dbms_random only allows for drawing uniformly distributed (all numbers equally likely) random numbers. As far as I know, other discrete probability distributions have to be …
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template …
Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures …
We at AMIS have a fairly long tradition when it comes to having developers attend the annual ODTUG (Oracle Development Tools User Group) conference. My first conference – while …
Imagine that you have to implement a table which must contain one row minimum and may not have more than one rows. So, on insert of a row you …
In a previous article, I discussed Dependency Injection (aka Inversion of Control and the Hollywood principle) and more specifically an implementation of Dependency Injection in PL/SQL. In that we …
These days I am working on a series of articles discussing Design Patterns and their implementation in PL/SQL. In previous articles, I have discussed Aspect Oriented Programming and Dependency …
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
Frequently our code has dependencies. Some are intrinsic dependencies, like the packages we need to invoke and the type definitions we rely on. Other dependencies are more like configuration …
One of the hottest topics in Java programming right now is probably Aspect Oriented Programming. Made popular by frameworks such as AspectJ and Spring, AOP refers to a new …
Last week I visited the Oaktable Seminar “Performance by Design” by Jonathan Lewis, held in Utrecht. I would like to share some of the topics of the seminar which …
From 21 February till 23 February the OakTable seminar Optimising Oracle (Performance by Design) by Jonathan Lewis was held. The seminar had been organised by Lex de Haan, who …
![Sorting PL/SQL Collections, the quite simple way (part two: Have the SQL Engine do the heavy lifting)]({"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"} "Sorting PL/SQL Collections, the quite simple way (part two: Have the SQL Engine do the heavy lifting)")