Re: Oracle Vs Sybase

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: DGUPTA@xxxxxxxxxxx, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Sep 2004 13:38:15 -0700


1. Sybase is case sensitive (eg) tables EMP ^= Emp ^= emp; Applies to
Column names too.
2. More so, i don't find the equivalent of AUTONOMOUS_TRANSACTION in
Sybase. May be someone else has.
3. Date formats 'look' different
4. Oracle Single Quote = Sybase Double Quote
5. You can do something like this in Sybase SQL (though  i am not sure
of the syntax)
   (IF Contraint EXISTS THEN
       DROP CONSTRAINT my_constraint;
    END IF
6. You have BEGIN TRANSCTION --> END TRANSACTION. More on this you can
refer to Sybase materials.



On Tue, 21 Sep 2004 14:47:02 -0500, "GUPTA, DEEPENDER"
<DGUPTA@xxxxxxxxxxx> said:
> Hi All,
> Does anybody have a comparison sheet for Oracle Vs Sybase?
> My Management is under influence of few people that Sybase is much
> cheaper
> than Oracle and have almost same features as Oracle, but I strongly
> disagree
> with this.
> I have already prepared a document to present my views but was wondering
> if
> anybody has a comparison with a more convincing figures or numbers which
> talks about the stability, security and other features of Oracle in
> comparison of Sybase.
> Thanks in advance..
> Dee
> --

Other related posts: