Re: Oracle Vs Sybase

AFAIK

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 ) GO
6. You have BEGIN TRANSCTION --> END TRANSACTION. More on this you can refer to Sybase materials.

HTH GovindanK   

On Tue, 21 Sep 2004 14:47:02 -0500, "GUPTA, DEEPENDER" <DGUPTA_at_entergy.com> 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
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l