On Oct 3, 1:08 am, Mohammed Azharuddin <[email protected]> wrote: > which is most powerful SQL or ORACLE? > > On Fri, Sep 30, 2011 at 11:20 PM, Michael Moore > <[email protected]>wrote: > > >
You really need to say what you mean and mean what you say. If you're using 'SQL' to refer to SQL Server then say so. Let's presume that is the case; Oracle and SQL Server are different databases, suited, generally, for different uses. Since SQL Server is Windows-based it is good for small to medium businesses that want a database product that is easy to configure, relatively easy to administer and works well with the Windows process/threading mechanism. Enterprise-wide applications are, generally, better suited to Oracle as it's designed as an enterprise-class database, suited to clustering and large volumes of concurrent transasactions. Significant improvements have been made to SQL Server (a more Oracle-like locking strategy as been introduced) however it still lags Oracle in area of high- availability. Oracle is also most widely used on the UNIX/Linux platforms, operating systems where SQL Server cannot run. Even though there are differences between them and that the both have different strengths it is difficult to say which is more 'powerful' as they are designed for (in my opinion) different purposes and markets. A Cadillac and a Mack truck have different strengths; certainly the Cadillac is faster on the highway but for hauling huge loads it's not the proper choice as the Mack truck will outperform the Cadillac in such tests. You can't replace one with the other and you shouldn't want to. In my view the question (and the argument it implies) is, well, silly as the Cadillac/Mack truck example illustrates. Both Oracle and SQL Server are good products; which one you use really depends upon how you intend to use it. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
