ABSTRACT

A view is virtual table. It is created in a SQL statement using one or more tables (views). Because views do not store data they only take small amount of disk space. Views are often used in database systems for various purposes.

This chapter introduces how to create views in GUI tools and SQL statements. Oracle SQL, T-SQL and MySQL samples are provided. By the end of the chapter readers will be able to create, update and delete views in Oracle, SQL Server and MySQL databases.