Oracle Forms - Overview of Trigger Categories

These topics provide overviews of commonly used triggers, grouped into the following functional categories: 

• block-processing triggers 
• interface event triggers 
• master-detail triggers 
• message-handling triggers 
• navigational triggers 
• query-time triggers 
• transactional triggers

How to know the dictionary Tables?

Everyone is interested to know what're the system tables, here's the query that helps you.


 select * from dict;

For example : If you want to know the system tables contains ROLE information:

SQL> select * from dict
 where table_name like '%ROLE%'

TABLE_NAME                    
------------------------------
COMMENTS                                         
---------------------------------------------------------------------------------------------------------------
USER_ROLE_PRIVS               
Roles granted to current user     
ROLE_ROLE_PRIVS               
Roles which are granted to roles     
ROLE_SYS_PRIVS                
System privileges granted to roles    
ROLE_TAB_PRIVS                
Table privileges granted to roles   
SESSION_ROLES                 
Roles which the user currently has enabled.                                                                                          
5 rows selected.