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.