Q about transactions

Hi All

What happens when two people try to update the same table simultaneously ?

The second one wait until the first one finish ?

Also what happens when the transaction is more complex then one update ?
I mean first I read some tables and then start to update / delete / insert
other tables ( using function for example )

will the second action will wait until the function transaction will end ?

Thanks in Advance :)

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://sites.canaan.co.il
--------------------------