Question:What are the advantages of using view?
Answer
Views can be quite advantages for a number of reasons: Simplicity: Saving the hassle of repeatedly querying multiple tables to retrieve this information. Security: Quite certain some information is inaccessible to third parties, such as the SSNs and salaries of employees. Maintainability: A view abstracts the gory details of a query.