17,377
社区成员
发帖
与我相关
我的任务
分享
-- Create table
create table TEST_INDEX
(
ID NUMBER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create or replace procedure pr_test_index as
begin
insert into test_index values(to_number(to_char(sysdate,'yyyymmddhh24miss')));
end;
declare job_test_index number;
begin
sys.dbms_job.submit(job_test_index,'PR_TEST_INDEX',sysdate,'sysdate+1/86400',true);
commit;
end;
/