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...


>> 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

>