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
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
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
