Monday, July 3, 2017

Find the Number of Concurrent Requests were completed for last 7 Days

select
trunc(REQUESTED_START_DATE),count(*)
FROM FND_CONCURRENT_REQUESTS
WHERE REQUESTED_START_DATE BETWEEN sysdate-7 AND sysdate
group by rollup(trunc(REQUESTED_START_DATE));


No comments:

Post a Comment