课程第18次

secoug

1. 
   
2. create table tvalue  ( a  varchar2(2000)) tablespace tbsaudit;
   
3. 
   
4. 
   
5. 
   
6. 
   
7. create or replace trigger trg_value
   
8. after update of salary on hr.employees
   
9. referencing new as new old as old
   
10. for each row
    
11. begin
    
12.   if :old.salary != :new.salary
    
13.   then
    
14.      insert into tvalue
    
15.       values( to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS')||' '||sys_context('userenv','ip_address')||' '||
    
16.              sys_context('userenv','os_user')||' '||
    
17.                sys_context('userenv','session_user')||' '||
    
18.                sys_context('userenv','current_user')||' modified from '||:old.salary||' to '||:new.salary||' the employee_id is '||              
    
19.           :old.employee_id );   
    
20.                  
    
21.   end if;
    
22. end;
    
23. 
    
24. 
    
25. select  * from user_errors;
    
26. 
    
27. select  * from dba_source s where s.name='TRG_VALUE';
    
28. 
    
29. select  * from tvalue order by 1  desc;

复制代码

	A
1	2019-10-20:22:38:25  oracle SYS SYS modified from 99999 to 100000 the employee_id is 100
2	2019-10-20:22:38:01  oracle HR SYS modified from 60005 to 99999 the employee_id is 100
3	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 206
4	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 205
5	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 204
6	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 203
7	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 202
8	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 201
9	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 200
10	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 199
11	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 198
12	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 197
13	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 196
14	2019-10-20:22:38:01  oracle HR SYS modified from 60000 to 99999 the employee_id is 195