1
1)約束創建
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); 百度SEO優化