Re: Is there any way to notify event from DB to PHP

I found this example.
for [ siganl ], I understand.
I can make this trigger with a table.

But, for test, I can't understand.
In where I can make it and how can I use it?

Thanks again.

--[ signal ]                                                
 create or replace trigger dept_aiud                        
 after insert on dept                   
 begin                                                      
     -- Needs execute rights.                               
     dbms_alert.signal( 'dept_modify', 'dept is modified' );
 end;                                                       
 /                                                          

                                                            
----[ Test ]                                                
 declare                                                    
     proc varchar2(20) := 'dept_modify';                    
     msg  varchar2(256);                                    
     stat number := 0;                                      
 begin                                                      
     dbms_alert.register(proc);                             
     dbms_alert.waitone(proc,msg,stat,60);                  
     if stat = 0 then                                       
        null; -- do something (??????)                              
     end if;                                                
     dbms_alert.remove(proc);