I love stories about performance problems. Recently, my friend Debra Lilley sent me this one: I went to see a very large publishing company about 6 months after they went live. I asked them what their biggest issue was, and they told me querying in GL was very slow, and I was able to fix quite easily. (There was a… Read more
One of the most anticipated new features that was introduced in APEX 4.0 was the ability to create your own APEX objects using the plugins framework. Since plugins were new when 4.0 was released there were just a handful of examples available online to help you learn how to create them. Today I’m pleased to announce that there’s a new… Read more
There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was reading my predecessor’s write up in Oracle Magazine (May 2007) on the subject, and keyed into the following snippet: Building a Chart When creating a report with the Chart style, the rule of thumb is to use SELECT group, series,… Read more
Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for executing the PL/SQL code. The default model (and the only one available until Oracle 8i (8.1.7)) is the Definer Rights model. When using this model the program executes under the authority of the owner (or creator) of the program. T… Read more
80% of all communication, it is often said, is nonverbal. The actual percentage is disputed – with experts quoting figures that range from 50% all the way up to 93% – but what is not in dispute is the fact that what is left unspoken is often as important as what is said. An almost direct parallel can be drawn… Read more
Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying to wrap your head around… Read more
This article on ORACLE-BASE describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise Linux 5 64-bit) using VMware Server 2 with no additional shared disk devices. The article is arranged in the following sections: Introduction Download Software VMware Server Installation Virtual Machine Setup Guest Operating System Installation Oracle Installation Prerequisites Install VMware Client… Read more
Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering the question “why does my query perform well in development, but it drags in test and production” is the same sort of game: you must identify where your environments differ, either obviously and subtly, then weigh those differences to determin… Read more
Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain regions in an APEX based application based on the selection of the user, for instance when a button or a link is pressed then you can of course use the Region Display Selector, but this takes up a region on… Read more
Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – ar… Read more
Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Grid Control. This article (read it in full on Oracle-Base.com) describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and… Read more
Forms was a great tool and stood for fast and easy development. You could create nice data entry applications in no time. But now some people think Forms is dead, it doesn’t have a future or it is at the end of its lifecycle. In this article I hope to prove they’re wrong. And unlike the first sentence to prov… Read more
You know the story. A group of blind men come across an elephant and each one feels a part of it. One touches the tusk and goes away thinking elephants are pointy, hard and sharp; another feels its side and is amazed at how wide and featureless elephants are; and one unfortunate man feels the elephant up its backside,… Read more
The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray Sending data back Using the bulk capabilities you can not only fetch data in one roundtrip to the database, but you can also use it to send data back to the database in a single roundtrip. Using the FORALL statement… Read more
Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to fill in this online survey about Oracle Forms. The results will be published during Oracle Open World. I’m interested in this topic (Forms and Forms Modernization) and I will be delivering a presentation at Oracle Open World about Oracle Forms(session… Read more
Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create a onesie, or piece baby outfit. I tried using my normal method of creating a simple png (pixel) graphic in gimp, however, when I tried to add that to something other than a regular old t-shirt, the application didn’t giv… Read more
A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and then check out the answer on nuijten.blogspot.com.
… Read more
Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a relatively small amount of code. Used improperly, however, it can cause all sorts of code maintenance headaches. Consider the following procedure. It uses the HR schema and sample data that comes with an installation of the Oracle database: CREATE OR… Read more
From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and sync various objects across Oracle databases. This was not fun work and I decided to evaluate some different tools to make this easier. The tool I have been working with recently is Red Gate’s Schema Compare for Oracle. In this… Read more
