Difference Between Sql/Server and Oracle

So you say locking mechanism is very good in oracle???
Can two users update the same row in a table at the same time???
Try it.

Quote:

---

Originally posted by bolero
So you say locking mechanism is very good in oracle???
Can two users update the same row in a table at the same time???
Try it.

---

Are you saying that the SQLServer behaviour is better or worse in this respect, and how?

Quote:

---

Originally posted by bolero
So you say locking mechanism is very good in oracle???
Can two users update the same row in a table at the same time???
Try it.

---

do you think that´s logical and good :-?

Quote:

---

Originally posted by cruser3
This reminds me to post:
Any1 here administering both Oracle and Sql server as I may have to do the same i.e manage a couple of SQL server db's sometime in the near future and was wondering if I could get any pointers on getting upto speed.

:)

---

Yeah - I'm in the same boat. We had a new app come in a couple months ago. It was an ugly mess and could run on either Oracle or SQLServer. We said to put it on SQL Server since my group doesn't support SQL Server. :) Now we are kicking ourselves. Thanks to Sarbanes Oxley, looks like we get the SQLServer and Informix stuff pretty soon. If we had known, we would have put it on Oracle in the first place because we at least have an Oracle DBA (me). Now we get to support SQLServer and Informix... while learning them at the same time.

do you think that´s logical and good :-?

I reality it may occur.

Quote:

---

Originally posted by bolero
do you think that´s logical and good :-?

I reality it may occur.

---

exactly. That's why oracle has locking.