A stored result set from a query.
You can use views in the same way that you use tables to produce other queries or reports. Views can simplify result sets, include summary rows such as counts or averages, and provide commonly-used expressions as named aliases.
For example, assume that you produce many reports that include the full name of your employees. Rather than create the same expression for every report, you could create a view to return the following columns:
where FULL_NAME is an expression that combines the columns LAST_NAME, FIRST_NAME, and MIDDLE_INITIAL. The view in this example would make it easier to create reports that include the employee's full name.
See your database documentation for more information on creating views in your database.