Home » SQL & PL/SQL » SQL & PL/SQL » query
query [message #254260] Thu, 26 July 2007 05:46 Go to next message
spsbombay
Messages: 29
Registered: June 2007
Junior Member


Good afternoon,

1 query. i m using oracle 9i.
lets i have a table emp which has 1 million of data. And i m doing
select count(*) from emp;


lets this query takes 60 seconds to fetch the result.
Now from another window i am inserting a record in this table which takes 10 seconds. means insertion will be finished before count query.

Can i see the effect of insertion in my count query.

Regards,
Prashant
Re: query [message #254267 is a reply to message #254260] Thu, 26 July 2007 06:11 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
A statement is consistent with the time it begins.

Regards
Michel
Previous Topic: How to add millisecond to TIMESTAMP datatype value
Next Topic: Sytem Triggers at Database level
Goto Forum:
  


Current Time: Fri Dec 09 17:44:30 CST 2016

Total time taken to generate the page: 0.25858 seconds