Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle licence question
> Name me 1 application written in "portable" SQL that runs scalable and
> performant on all those 3 platforms - it just doesn't exist. SQL Server is
> NOT Oracle is NOT DB2.
Its my stance too - ask Celko, I'm always bashing him because of his blindly following standards over scalability.
But, its a real requirement that vendors trying to support multiple platforms face - just go and ask one who's application supports all three.
Personally, I think each database should support full FIPS so we can have a professional standard approach that we could follow, and then if the particular query/problem trying to be solved doesn't scale we then resort to vendor extensions.
-- Tony Rogerson SQL Server MVP http://sqlserverfaq.com - free video tutorials "Matthias Hoys" <anti_at_spam.com> wrote in message news:4401f941$0$11130$ba620e4c_at_news.skynet.be...Received on Sun Feb 26 2006 - 13:12:12 CST
>> But to reiterate the original point - a good database professional will,
>> given a problem try and code it to FIPS 127-2 FULL (ANSI 92) and if it
>> doesn't perform well enough will then look at vendor extensions. If you
>> are writing an application that needs to run on SQL Server, Oracle and
>> DB2 then you need to write portable SQL, that seems to be lost on HansF
>> and probably DA too.
>>
>
> Name me 1 application written in "portable" SQL that runs scalable and
> performant on all those 3 platforms - it just doesn't exist. SQL Server is
> NOT Oracle is NOT DB2.
>
> Just my thoughts ...
> Matthias
>