sábado, 9 de septiembre de 2017

TRIGGER TRUNCATE

create table event_log 
(log_date varchar2(36), 
event varchar2(36), 
username varchar2(36), 
owner varchar2(36), 
object_name varchar2(36), 
object_type varchar2(36), 
dbname varchar2(36) 
); 

create or replace trigger truncate_trg 
before truncate on database 
begin
insert into event_log 
values(sysdate, 
ora_sysevent, 
ora_login_user, 
ora_dict_obj_owner, 
ora_dict_obj_name, 
ora_dict_obj_type, 
ora_database_name) 
end; 

No hay comentarios: