PaulB (2/9/2009)
jgrubb (2/9/2009)
... but aggregates and functions are different.Not to mention Triggers, Cursors, Partitioning and stuff that does not exist in the SQL Server world like bitmap indexes, star-transformation, materialized views, etc. - just to mention a few of them 😉
Picky picky. I was referring to the context of queries. Don't forget also that Oracle connections default to explicit xactions, rather than implicit as in SQL Server.
If tried to catalog the differences in detail, we'd crash the poor forum server! :w00t: