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 -> Sybase vs Oracle - which is better?

Sybase vs Oracle - which is better?

From: Karl Zdero <zderok_at_viaginterkom.de>
Date: 1998/11/16
Message-ID: <364FF77D.C0BCCA8A@viaginterkom.de>#1/1

The usual techie debate continues,
Is Sybase better than Oracle or is Oracle better than Sybase?

When it comes to benchmarks, the www.sybase.com site says that Sybase holds the world record, but www.oracle.com says it holds the record. I see in www.tpc.org that the fastest tpc is with Oracle!

Now apart from benchmarks, what makes either database better?

I like Oracle as I've used it the most, heres why.

+ sqlplus is superior than isql, at least I can check return error
codes.

+ PL/SQL is more powerful than TRANSACT/SQL
+ I can see qll SQL activity for a particular session (SQLAREA),
can't do it in Sybase?

+ Oracle comes standard with many utilities, whereas Sybase doesn't
+ Oracle has more options with triggers than Sybase. e.g. per row
triggers and per statement

       (In Sybase you must write a cursor loop to action a multiple row insert for example)

+ Monitors are standard with Oracle. (Sybase dont think so)
+ Row level locking been for years in Oracle, only recently in
Sybase.

+ Oracle can select data from another database on another server
(dblink) Can Sybase? Received on Mon Nov 16 1998 - 00:00:00 CST

Original text of this message

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