Please send your Questions & Answers or Feedback to ""

Please send your Questions & Answers or Feedback to ""

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.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter