I need to list the Item Fulfillment (lastmodifieddate) in the last hour. Any of you have an example ? Thanks in advance

Something like this

select * from transaction where type = 'ItemShip' and lastmodifieddate >= to_char(sysdate - 1/24)