Select * from TABLE_NAME where CREATED_DATE_COLUMN >= SYSDATE - 10
UPDATE TABLE_NAME SET COLUMN_NAME = SYSDATE;
select * from EMPLOYEE where JOINING_DATE between to_date('01-MAY-14', 'DD-MON-YY') and SYSDATE