11)约束创建
2
3a:在已有重复列上创建唯一约束
4alter table BOOK_POOL
5add constraint unique_POOL_RELEASE unique
6(DOCTORID, WORKID, VISITSDATE, VISITS_ID, RECORDSSTATEID)
7enable novalidate;
8
9注释:job1(代表job唯一标识)
102)job管理
11--查看job
12select * from dba_jobs order by job;
13
14--创建job
15begin
16 dbms_job.submit(:job1, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
17end;
18
19--删除job,job1代表:job任务的唯一标示号
20begin
21dbms_job.remove(job1);
22end;
23
24--停止job
25dbms_job.broken(job1,true);
2
3a:在已有重复列上创建唯一约束
4alter table BOOK_POOL
5add constraint unique_POOL_RELEASE unique
6(DOCTORID, WORKID, VISITSDATE, VISITS_ID, RECORDSSTATEID)
7enable novalidate;
8
9注释:job1(代表job唯一标识)
102)job管理
11--查看job
12select * from dba_jobs order by job;
13
14--创建job
15begin
16 dbms_job.submit(:job1, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
17end;
18
19--删除job,job1代表:job任务的唯一标示号
20begin
21dbms_job.remove(job1);
22end;
23
24--停止job
25dbms_job.broken(job1,true);