Re: Databases

Answers interspersed below.

sasi_mannava wrote:

> Hi,
> Pl.give me a detailed answer for my follwing doubts.
>
> 1) What are all the fundamental differences between Oracle and
> SQL Server?
>

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.

>
> 2)what are all the Best Practices in Oracle and Sql Server

Question is unanswerable. You need to have specific well-thought out questions. This question would require taking a CS degree level course.

>
>
> 3)Localization and Internationalization Using Oracle.

This is an incomplete sentence at best. I have no idea to what you refer.

>
>
> Pl.suggest me any sites having relavent info for the above topics.
>
> Thanks in advance.
>
> Sasi
>
> --
> Posted via http://dbforums.com

http://tahiti.oracle.com
http://otn.oracle.com
http://technet.oracle.com
http://docs.oracle.com
http://store.oracle.com
http://www.oracle.com

Daniel Morgan Received on Mon Dec 16 2002 - 19:38:07 CET