Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and Microsoft SQL Server

Re: Oracle and Microsoft SQL Server

From: Bill Bearden <bbearden_at_quincy.glenayre.com>
Date: 1997/06/19
Message-ID: <01bc7ca7$b17d68e0$1d51e69d@qcy_erp_6>#1/1

The comment below that SQL Server 6.5 is a strict subset of Oracle 5.x is ridiculous. Oracle 5.x was fairly backward compared to today's RDBMS's. Oracle's great leap forward was Oracle 6. That is when Oracle began its march to #1. IMNSHO, Oracle RDBMS is #1 and by a good sized margin, especially for large applications.

<rebuttal to stupid comment>

* SQL Server has temporary tables (very handy!).  Oracle does not.
* SQL Server has the 'money' datatype.  Oracle does not.
* SQL Server has bcp, a great input/output utility (In and out have same
syntax!). Oracle has SQL*Loader, a great input utiltity (when Oracle adds unload to SQL*Loader, it will win easily) * Don't even talk to me about copying entire 1GB tablespaces which only have one row. (No, export is not a valid hot backup technique...) </rebuttal to stupid comment>

Overall, Oracle has the features war won. Overall, it isn't even that close. But Oracle is also much more complicated than SQL Server. While this excites me (we won't go in to that), some users are not willing to make that trade off. And that is how it should be.

Bill Bearden
Consultant

Mark McNulty <mmcnul_at_jpmorgan.com> wrote in article <5o8qph$l8f$1_at_hardcopy.ny.jpmorgan.com>...
> In article 920_at_feist.com, rrbatra <rrbatra_at_feist.com> () writes:
> [snip a bunch of good points before this stinker below]
>
> > There is nothing which SQL Server does and Oracle does not. In fact,
> > all features found in SQL server 6.5, were there in Oracle 5.x or
> > so...For a list, look in any PC week, Oracle loves comparing it with
 SQL
> > Server.
>

 <stuff snipped>
>
> Actually, while Oracle does have some good features, SQL Server(and
 Sybase)
> do have some that Oracle doesn't, especially those related to stored
> procedures, where Oracle is actually behind. Try returning multiple
> rows, or even multiple result sets, from an Oracle stored procedure. In
> Oracle, you have to use a work-around. In Sybase, I can say
>
Received on Thu Jun 19 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US