Home » SQL & PL/SQL » SQL & PL/SQL » Select query while Insert/Update on a table (Oracle 10g)
Select query while Insert/Update on a table [message #418790] Tue, 18 August 2009 09:54 Go to next message
victory_nag
Messages: 36
Registered: June 2008
Location: CA
Member
Hi,

I have one doubt.
If i query a table xyz it takes 20min(run time of the query).
Some one has inserted a row in table xyz and commits it just after I have started to query the table.

Will the result set includes the new row? If so how?



Re: Select query while Insert/Update on a table [message #418793 is a reply to message #418790] Tue, 18 August 2009 09:55 Go to previous message
cookiemonster
Messages: 12410
Registered: September 2008
Location: Rainy Manchester
Senior Member
Query results are as of the time the query started. So no, you won't see the newly inserted row.
Previous Topic: how to make the value with comma separated values by grouping
Next Topic: How to update a Column with specific Serial ?
Goto Forum:
  


Current Time: Wed Dec 07 05:01:27 CST 2016

Total time taken to generate the page: 0.30635 seconds