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));
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