PL/SQL show results from last X hour
Last 15 mins where last_modified_on >= (sysdate-0.15/24) Last one hour where last_modified_on >= (sysdate-1/24)
PL SQL Select top 1 row
SELECT * FROM (SELECT * FROM PIM_CONTACT t ORDER BY last_modified_on desc ) WHERE ROWNUM = 1;
PLSQL current DB date and time
select CURRENT_DATE from dual;