Hi All

The advantages of View are under below

1. It reduces the complexiety of Sql Quey.

2. For security purpose. As it doesnt allow you to know about the base tables.

The advantages of View are:

security: only selected column from a table made available to view.

Complaxity: write a complex query and assign this query to a view so next time no need to write that complex query.

Faster: view refers to a query which is already parsed so again it does not go to that stage

efficient: while writing trigger a condition may arise trigger makes the table in mutating state so use of views in this sanirio makes it easy.

Hi Rampratap

U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?

Thanks

Pratima