VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'TRUNCATE table A;',
SYSDATE, 'trunc(last_day(sysdate)+1,'dd')+1/6');
commit;
end;
/
begin
DBMS_JOB.SUBMIT(:jobno,
'TRUNCATE table A;',
SYSDATE, 'trunc(last_day(sysdate)+1,'dd')+1/6');
commit;
end;
/
trunc(sysdate,'hh')+1/24