Category: Database

Probably one of the oldest database scripts around is the sql.bsq file. First comments described in the heading of this file date from 1994 (“anori – 11/17/94 – ADT …

Coming Wednesday, we organize the fourth AMIS Academy (Wednesday 27th June – free mini-conference at our place), a mini-conference with 16 presentations in four consecutive timeslots. One of our …

The official launch is at hand. In less then 3 weeks Oracle 11g will be presented at the world during a, probably, great launch event in New York. AMIS …

Ever wondered how they Easter date is determined? And, even more important, how it is to be maintained in you application. Manually updating the date every year is an …

From different posts on this blog it should be clear by now: the ODTUG Kaleidoscope conference has taken off. I am writing this post as I am attending the …

The ODTUG 2007 Kaleidoscope conference is just around the corner, starting in two days time. AMIS will attend with a team 6, doing a grand total of 9 presentations …

When running the http (CPU April 2007) patch on the Oracle EBS 11.5.9, I received some errors…It seemed the oraInventory was not valid, at least the http entry was missing. …

According to the post of Eddie Awad, Oracle 11g will be released at the 11th of Juli, 2007. So the time we actually can post about it comes near. …

Oracle and Java are two of the main areas of our (at AMIS) expertise. They come together in many different ways, but particularly in Oracle Toplink. Peter Ebell, a …

During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is …

Hate? Let’s say it is a love / hate thing, but I can’t help myself. I am a script nerd and probably always will be, but even I have …

For the third year running, Alex and I will present the Oracle SQL Quiz on the ODTUG conference. This Quiz has a dozen or so questions on Oracle SQL …

I often need a database to perform some quick tests. I usually start my Oracle instance. This takes some time and for most things it’s overkill. So a database …

Next month, the ODTUG 2007 Kaleidoscope Conference takes place in Daytona Beach, Florida. 125 presentations on Oracle Development tools related topics – database, SOA, BI, ADF, JEE 5, AJAX, …

I believe I am careful when I am on the internet. My personal laptop is almost a fortress regarding protecting me from internet scum, so I try to protect …

Thanks Doug, for pointing out one of the first Oracle 30th anniversary links: http://www.oracle.com/oramag/profit/07-may/p27anniv_timeline.pdf. I had the privilege to meet Mr. Jacobs in person for two times now. Two …

The changelog of Apex 3.0 mentions something about featuring shuttleboxes. Don’t get too enthousiastic, you still have to do a lot of work yourself. And it’s pretty limited, because …

With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way …

The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files …

I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or …

There are many things that can help make this world a better place. A pure SQL-based Gantt-chart is not one of them. However, that is exactly what this article …

A great example of how one could use the Oracle XMLDB functionality in a unforeseen way in your relational world, is being demonstrated by Laurent Schneider in his article …

Last year our firm (AMIS) celebrated its 15th anniversary. This year Oracle celebrates its 30th year of its existence. In that reflective light, I remembered a nice “Easter egg” …

Implementing a shared APPL_TOP with E-Business Suite is common practice these days. Since 11.5.10, there is also support for a shared technology stack (8.0.6 and iAS ORACLE_HOMEs). But what …

Last night, we hosted an inspiring and thought provoking AMIS Query, with some 70 developers, project managers and primarily DBAs. The presentator was well known performance expert ("I just …

It seems innocent, a few lines of code used twice in the same application. But before you know know it those lines appear 272 times in your application! You …

Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to …

Allright, that is an exaggeration. Hugely. But it cost me some headache before I realised what was my problem. I still had HTML DB 1.6 running and I thought …

AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators How the Middle Tier is Slowing Down Your Database …

Sometimes you are writing some codes and things really come together well. Let’s imagine, you are writing a little tool in ApEx for registering hours on a project. The …

After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G. Before I could configure R12 in …

I know, it’s a little bit of an aggressive statement, but if you think about it, it gets to you… Regarding performance and “best practices”. Let’s do this, a …

As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i. I had had the opportunity …

I got up at 5 o’clock (CET) in the morning on Saturday and made my way to Schiphol airport, so Gerwin and I could take our plane to Dallas, …

I will be attending HOTSOS 2007 next week; and to be honest, I am not really into it yet. Despite, I guess and hope the great presentations, keynotes and …

During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me …

This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of …

Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented. col1 col2 value 2 …

A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as …

Yesterday evening I started preparing for the upcoming Oracle PL/SQL Programming Test-A-Thon. I strongly believe that building your own programs to perform a functionality, which is already provided as …