Discussion On Views

There are two types of views in oracle. They are static views and dynamic views.

Views which are starting with USER_,ALL_,DBA_ are called static views.

Static views gets the information from data dictionary(system.dbf).

Normal users can issue  a select statement on USER_ as well as ALL_ views.

Only DBA can issue a select statememt on DBA_ tables.

Note : we should not issue any DML statements on the Base tables.

Note : The only base table where we can issue DML statement is aud$.

All $tables are called base tables.

All V$ views are called Dynamic views. Dynamic views are  going to get the information from the

instance as well as data dictionary.Dynamic views give accurate information compared to static views.