Her 5 saniyede insert commit

tablo

CREATE TABLE HR.GG_TAB ("ID" NUMBER(9,0), "TARIH" DATE ) ;

1	CREATE TABLE HR.GG_TAB ("ID" NUMBER(9,0), "TARIH" DATE ) ;

sequence

CREATE SEQUENCE "HR"."GG_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 751962 CACHE 200 NOORDER NOCYCLE ;

1	CREATE SEQUENCE "HR"."GG_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 751962 CACHE 200 NOORDER NOCYCLE ;

prosedure

create or replace PROCEDURE GG_PROC AS
BEGIN
INSERT INTO HR.GG_TAB VALUES(HR.GG_SEQ.NEXTVAL,SYSDATE);
COMMIT;
END;

create or replace PROCEDURE GG_PROC AS

BEGIN

INSERT INTO HR.GG_TAB VALUES(HR.GG_SEQ.NEXTVAL,SYSDATE);

COMMIT;

END;

Schedule 5 saniyede bir çalıştıracak

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => '"HR"."GG_JOB"',
job_type => 'STORED_PROCEDURE',
job_action => 'HR.GG_PROC',
number_of_arguments => 0,
start_date => NULL,
repeat_interval => 'FREQ=SECONDLY;INTERVAL=5',
end_date => NULL,
enabled => FALSE,
auto_drop => FALSE,
comments =>'GG_JOB desc');

BEGIN

DBMS_SCHEDULER.CREATE_JOB (

job_name => '"HR"."GG_JOB"',

job_type => 'STORED_PROCEDURE',

job_action => 'HR.GG_PROC',

number_of_arguments => 0,

start_date => NULL,

repeat_interval => 'FREQ=SECONDLY;INTERVAL=5',

end_date => NULL,

enabled => FALSE,

auto_drop => FALSE,

comments =>'GG_JOB desc');

DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"HR"."GG_JOB"',
attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);

DBMS_SCHEDULER.enable(
name => '"HR"."test"');
END;

DBMS_SCHEDULER.SET_ATTRIBUTE(

name => '"HR"."GG_JOB"',

attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);

DBMS_SCHEDULER.enable(

name => '"HR"."test"');

END;

Enable/Disable

BEGIN
DBMS_SCHEDULER.enable(name=>'"HR"."GG_JOB"');
END;

BEGIN

DBMS_SCHEDULER.enable(name=>'"HR"."GG_JOB"');

END;