Re.Dirty reads

Hi Everybody, What would be the impact on database and its integrity if the application has used DIRTY READ during INSERT. Thanks in advance. Sushil... _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

----LNX_Wed_May_14_2003_16:06:04_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2003.05.14 15:37:40 >Sender: Sushil Shir.... <sushilps@hotmail.com> > >What would be the impact on database and its integrity if the applicatio= n >has used DIRTY READ during INSERT. = For the INSERT there exists nothing like a DIRTY READ (or DIRTY INSERT) ,= isolation levels apply only to SELECT (including SELECT FOR UPDATE) . But if you use a SELECT first to decide what or where to insert than ther= e could arise problems, for example if you want to copy entries from one table/applicat= ion to another your select could read phantoms. = Regards, Andreas Kutsche = ------------------------------------------------ SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastra=DFe 3 A-5015 Salzburg = Telefon : +43 662 4470 24423 E-Mail : Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------------ = ----LNX_Wed_May_14_2003_16:06:04_V3.33----