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!

Last hour transaction query

Hussain#Apr 2 2019 — edited Apr 2 2019

Dear,

I am getting some trouble making query which must have take last hour record from Database, Can you pls show give your suggestion on below query. Actually we have
schedule job which will run every hour, now what is the between query which consider last hour query, let suppose if database job trigger at 10 then between 9 to 10 all record should be
get through query.

TransactionDate Between sysdate - interval '59' minute aa,sysdate - interval '0' minute

Thanks.

Added on Apr 2 2019

12 comments

2,664 views