DATABASE OBJECTS :-
The different database objects are:
- Tables
- Views
- Synonyms
- Indexes
- Indexed views
- procedures
- Functions
- DB triggers
VIEWS :-
- A view is a “ subset of a table” and also called “virtual table” (or) “stored query”.
- Views are mainly created for Security and Simplicity.
- By creating views, specific columns & specific rows can be granted to users.
- Views are two types :-
(A) SIMPLE VIEWS
(B) COMPLEX VIEWS.