What is array size and transaction size

deepesh · Post by **deepesh** » Tue Sep 20, 2005 9:14 am

What is transaction isolation?
what do u mean by serializable, read commited, read numcommitted?

Divam Singh · Post by **Divam Singh** » Thu Sep 22, 2005 4:00 am

read uncommitted:- you can read an uncommitted transaction that might get rolled back later.

serializable:- prevents other users from updating or inserting rows into the data set until the transaction is complete.

read commited:- It does not ensure that the data will not be changed at the end of the transaction. Since it will not read uncommited data.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 22, 2005 5:31 am

Transaction isolation level is a concept originally introduced as part of the ODBC standard, by Microsoft. The ultimate reference, therefore, is the ODBC 3.0 API Programmer's Reference and SDK, from Microsoft Press.

pravin_dsx · Post by **pravin_dsx** » Fri Aug 17, 2007 5:00 am

I have situation where I have to insert rows into a table and after the insert is complete update some rows in the table. Is isolation involved here?

chulett · Post by **chulett** » Fri Aug 17, 2007 6:39 am

No, not really. If you do end up having an issue with your job, even if it seems to be related to this topic, please start a new post. Make sure we also get all the gory details of your requirements and job design as well.