Category: PL/SQL
I do not like the P word. Oracle Portal has never quite enthralled me like some or rather many other products from Big Red have. But I think I …
Building applications in our corner of the world typically revolves around databases. The most important bit about an application is not the application, but rather the data it creates …
Internationalization, multi-linguality, NLS support for JSF applications – or any Java powered application for that matter – is an important topic. And Resource Bundles are the way to deal …
Analytical Functions are a joy in my life as an Oracle developer. I have been demonstrating them, presenting on them, teaching on them and using them. Today I had …
I am currently involved in the migration of a pretty substantial application, developed with Oracle Designer’s Web Server Generator, to the Oracle ADF technology stack, using JHeadstart. You know …
Steve Muench has published the 10.1.3 version of his JHeadstart tutorial at: Building Enterprise JSF Applications with Oracle JHeadstart for ADF (10.1.3) – A step-by-step, end-to-end tutorial on how …
One of the things that you never expect to go wrong will of course go wrong anyway, as I experienced today at one of my customers’ sites. We ran …
For the past four weeks, AMIS has been host to the Oracle Discovery, a training program – some might say a boot camp – for nine junior Oracle developers, …
When defining sequences, you can choose to set a cache size or disable the sequence cache: create sequence tst_nc2 start with 1 increment by 1 nocycle nocache; create sequence …
Riddle me this: Can an object exist in all_objects before it is created?Well no, of course not. I was under the assumption that if you create a table with …
At the customer site where I work, we are using an Oracle 9i. More specific a 9.2.0.5 database. While demonstrating to one of my colleagues when an index can …
Oracle just released ApEx version 2.2. Here is the list of changes. Most of the changes do not come as a surprise as they were already mentioned in the …
One of our tables stores configuration data. Two stored procedures interact with this table; One of them uses the data for further processing; The other procedure is used to …
I just got started using XMLType. I know maybe a little late to start to look at it, but better late than never, right? Anyways, to see what is …
Back in 1998 or 1999 I filed a bug/enhancement request in the Oracle bug database. As I was still working at Oracle back then and I had direct access …
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via …
Case: In a table there is a column customer_code and a column status. The allowable values of status are I, P, C, E. The status indicates that a record …
From June 17th until June 21st I attended the ODTUG conference in Washington DC. I focused mainly on .Net and Apex. In Holland quite a few customers are moving …
Demo application advanced Forms features (ODTUG 2006 version) Last June, I held a presentation at the ODTUG conference in Washington DC “Oracle Forms: Productivity with new choicesâ€. During this …
For a reporting application demanding numeric accuracy we needed a functionality for rounding (positive) numbers given in string representation while controlling their number of significant digits. I found the …
Last night, the ODTUG 2006 Conference Committee announced that all handouts and presentations from this year’s (well, in fact that is last week’s) conference are available for download from …
With the regular expression functionality in Orcale database 10g some handy build-ins of the UNIX pattern matching language AWK are easily implemented. I myself use AWK split() function quite often in AWK …
For me, one of the highlights of this year’s ODTUG conference was the presentation of Steven Feuerstein about PL/SQL unittesting, “Six simple steps to unit testing happiness“. While unittesting …
Right after the Oracle Quiz Lucas and I presented last week on ODTUG, I went to Mogens Norgaard’s presentation. Here is a short report from that session, you may …
Last week at the ODTUG conference, I did a presentation on Analytic Functions. Later on someone came up to me and asked me if there is also a Median-function …
The problem: I recently had to resolve a problem at a client’s site where an automated database provisioning process was regularly failing due to LAN outages. Under normal circumstances, …
Today was another AMIS day at ODTUG 2006. After yesterday’s three presentations, today we have done another three. Aino kicked off at 8.30 AM with his presentation on How …
Another message from ODTUG 2006. The main development tools for most of the participants on this conference is Oracle Forms. Today was an important session, by Grant Ronald (Principal …
The title of this article is hugely misleading. Or somewhat at least. The presentation has to take place yet. And it is my own – so how great can …
It's Showtime! Today at ODTUG 2006, Alex and I are presenting our Oracle Quiz on SQL and PL/SQL – the water is still burning. We will present our audience …
Routeplanners have always been somewhat magical in my eyes. Finding the quickest route from A to B in a graph of thousands of points and connections. I have tried …
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 …
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 …
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 …
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 …
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 …
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 …
It took a few months, but I finally start appreciating the Oracle SQL Developer developed by Oracle (The Project Formerly Known As Raptor). There are still some bugs, for …
![Quality Check for Domains in Oracle Designer – fighting problematic AVCON check constraints]({"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"} "Quality Check for Domains in Oracle Designer – fighting problematic AVCON check constraints")