Date function in Oracle
examples of date function:
insert into mydate values (sysdate -1);
insert into mydate values (sysdate - 6/24); # 6 hours ago
insert into mydate values (sysdate - 720/1440); # 12 hours ago
click read for complete example
usage
click read for complete example
usage
delete noprompt archivelog until time 'sysdate - 1';
delete archivelog all backed up 1 times to device type disk completed before 'sysdate-6/24';