Updating a join view oracle
The primary use of views is to present data to users of an application.
Views can be used in place of tables in your Access front-end application, whether you're using an Access database or an Access project.
The SQL-92 standard also mandates that views cannot be sorted with an values with a view; to support that, it also supports sorting.
A user can query a single view instead of having to learn complex join syntax and understand the structure of your database.
So, a view that returns the top 100% by sales would essentially be a sorted view.
The triggers in views are covered later in this chapter.
They can be used to provide row- or column-level access to data, to wrap up complex joins, to perform complex aggregate queries, and to otherwise customize the display of data. In this chapter, learn how to define, create, and modify views, and how to perform index analysis and optimize performance in SQL Server. The biggest problem is that just when you get used to accepting a limitation, Microsoft comes up with an amazing, new feature that overcomes it!
It's great to get the extra features, but it makes it harder to nail down exactly what you can and cannot do with views.