Description of a view should include a list of other database objects (e.g., table, index, synonym, sequence) and the following:
- Views can be described as virtual tables that contain groups of data from various tables and are used to save time or limit user access to sensitive data.
- A view is stored in the database as a piece of code and does not take up a large amount of memory as other database objects do.
- Each time the user asks to see a view, the code that created the view is executed and displayed. Consequently, the view contains the most up-to-date information as defined by the creation criteria.