A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.
D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.
E. The STATE column of the job table will be set to COMPLETED for the job.
答案:(A、B、C)
解析:
DBMS_SCHEDULE.CREATE_JOB
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1298711/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1298711/