全部博文(39)
发布时间:2013-11-16 08:58:23
CREATE SEQUENCE job_seq CACHE 30;CREATE OR REPLACE TRIGGER tri_grant2developers AFTER ddl ON DATABASEDECLARE v_jobname VARCHAR2(200) := 'DDL_JOB'||job_seq.NEXTVAL; v_sql VARCHAR2(2000);BEGIN IF (upper(ora_dict_obj_owner) IN &n.........【阅读全文】