Re: Differences Between Oracle and SQL Server

The "real" differences between SQL Server and Oracle have absolutely nothing to do with what you are looking for or finding. Syntactic differences are unimportant. And with version 9i the outer joins are no longer different as Oracle supports both syntaxes.

The significant differences are in multiversioning, defining transactions, and locking.

Daniel Morgan

Justin Wigg wrote:

> Hi all.
>
> Having never used Microsoft SQL Server before, I'm after a kind of unbiased
> list of differences between Oracle and SQL Server approaches to the SQL92
> standard. I've done several Google searches but am having trouble finding
> what I thought would have been a fairly common query.
>
> Basically what I'm after is a list of things like:
>
> Concatenation:
> Oracle SQL Server
> || +
>
> Left Outer Joins
> Oracle SQL Server
> (+)= LEFT OUTER JOIN
>
> Anyone able to point me toward a reasonably definitive on-line source of
> things like that?
>
> Many thanks...
> --
> "Managing senior programmers is | Justin Wigg - Hobart, AUSTRALIA
> like herding cats." - Dave Platt | Reply: justinwigg_at_yahoo.com
Received on Tue Mar 12 2002 - 09:50:28 CST