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@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
> --
> http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: