Hi I saw this list posted on an Oracle Newsgroup a while back :-)
Oracle has multiversioning. SQL Server has no equivalent In Oracle reads don't block writes and writes don't block reads In Oracle there are unlimited row level locks In Oracle there is no such thing as lock escallation or page level locking In Oracle there is no need to use temp tables to accumulate intermediate level results In Oracle phyiscal transactions can be as large as logical transactions. No need to fragment them Oracle runs on platforms other than Windows Oracle has many trigger types not available in SQL Server Oracle lines the pockets of Larry Ellison rather than Bill Gates. Which means that someone is having fun with your money rather than just hoarding it. Also look at the link below for a longish (400+ lines) and very detailed technical comparison. http://groups.google.com/groups?q=faulkner+oracle+sqlserver&hl=en&lr=lang_en &ie=UTF-8&oe=UTF-8&newwindow=1&selm=FssV9.25204%24jM5.66998%40newsfeeds.bigp ond.com&rnum=4 - Dale ----- Instant schema documentation for free? Check out the DDL to HTML facility in the freeware DBATool. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
