I had used this function sometime back and had totally forgotten about it. Used it again in a procedure where i had to subtract minutes value stored in a cursor variable (or local variable) of a procedure from systimestamp and compare it against created_date of a table column.
select count(*) from my_db.my_table
where created_date > (systimestamp - numdstointerval (cursor_loop_rec.minutes, 'minute'));
In this if count > 0 then instances have been created for that particular composite in the required time frame.
Hope this helps...
No comments:
Post a Comment