Re: Challenging SQL Query Problem. Can you solve it?

From: HansF <News.Hans_at_telus.net>
Date: Thu, 22 Dec 2005 23:08:52 GMT
Message-Id: <pan.2005.12.22.23.08.51.215405@telus.net>

On Thu, 22 Dec 2005 14:48:10 -0800, Karen Hill wrote:

>
> DA Morgan wrote:
>

>>
>> There is no such thing as an Oracle database without it.

>
> In the interest of portability, I have to be mindful that I don't use
> an Oracle only function.
>

Please read Chapter 1 of Tom Kyte's "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions" for a good discussion on the reality of your database indeependence requirement.

Your desire to stay database independent is simply going to cause your customers to increase their cost. Database independence means not taking advantage of the vendor's capability, which in turn means more CPU cycles, and THAT means more CPU and therefore more licenses to do the same job.

What you really want is intelligent use of those features.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Thu Dec 22 2005 - 17:08:52 CST