Regularly inserting data into Oracle

1 Creating a Stored procedure

Create or replace procedure Job_proc is
Begin
Insert into YY (Yid) values (sysdate);
End

2 Create Job

DECLARE
JOB Binary_integer; --Task ID
V_begin DATE; --Start time
V_interval VARCHAR2 (50); --Time interval
BEGIN
v_begin:=sysdate;--current time to start execution
V_interval:= ' trunc (sysdate, ' mi ') + 1/(24*60) '; --executes once per minute and can be changed
Dbms_job. SUBMIT (JOB,
' Job_proc; ',--stored procedure name
V_begin,
V_interval,
FALSE,
0,
FALSE);
COMMIT;
END;

Regularly inserting data into Oracle