Home » SQL & PL/SQL » SQL & PL/SQL » query
query [message #254260] Thu, 26 July 2007 05:46 Go to next message
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.

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

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

Current Time: Thu Jun 22 17:34:18 CDT 2017

Total time taken to generate the page: 0.13714 seconds