Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get the count of each minutes

Srikkanth.MFeb 4 2011 — edited Feb 4 2011
Oracle 10 DB

Hi All


I using this query to get the count of records fetched by the concurrent program per min,

select count (distinct b.attribute2)
from oe_order_headers_all a,oe_order_lines_all b
where a.header_id=b.header_id
and b.flow_status_code ='AWAIT_QUINTIQ_BOOK'
and to_Char(b.last_update_date,'DD-MON-YYYY HH24:MI:SS') between '19-JAN-2011 02:00:01' AND
'19-JAN-2011 02:00:02'

This is used to get the count of records fetched at one mins

How to find the count of last 10 mins ie 1 mins count 2.00 to 2.10


Thanks & Regards
Srikkanth.M
This post has been answered by Nimish Garg on Feb 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 4 2011
3 comments
3,847 views