Hands-On Oracle Database 10g Express Edition for Windows

Views

Once you define the tables in a database, you can start to focus on other things that enhance the usability of the application schema. You can start by defining views of the tables in your schema. A view is a database object that presents table data. Why and how would you use views to present table data?

You can use a simple view to expose all rows and columns in a table but hide the name of the underlying table. For example, you might create a view called CUST that presents all customer records in the CUSTOMERS table.

You can use a view to ...