Category: Languages
JHeadstart is one of the tools we use quite successfully here at AMIS. We have written on this blog about JHeadstart and ways to extend, enhance and optimally benefit …
Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember …
Tuesday - Getting into the spirit I am just joking, so far I haven't seen an Elvis look-a-like in town, but I would be very interested how Thomas Kyte …
Yesterday (Monday) was the Keynote speech by Thomas Kurian, Oracle VP, that started the Oracle Develop event. In what can be described as a crisp, well organized presentation, Kurian …
It's amazing how much Lucas already put to "paper", despite all the mishaps we already encountered. The last two days I lost track on Lucas because he has completely …
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 …
It's almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I …
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 …
The Oracle 10g Database release saw an extension of the MERGE statement with a DELETE clause. That by the way makes MERGE the only statement that can fire all …
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 …
XFire is a java SOAP framework. Of course there is Axis, but I think XFire can replace Axis. Axis is quite a good framework, but I think XFire is …
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 …
Lucene is a text search engine written in Java. It’s very easy to use (for both developers and users) and fast. The creator of Lucene (Doug Cutting) started with …
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 …
When trying to create anonymous data, I encountered an unexpected side effect of the updateXML statement while updating XML documents in an Oracle 10gR2 (10.2.0.1.0) EE database. I got …
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 …
![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")