next up previous contents
Next: Destroying Schema Objects Up: Oracle Basics Previous: Query the table   Contents

Creating and Querying a View

Views are simple says to make tables a little more comfortable, especially as they grow large and seemingly out of control.

SQL> create view cell_view as 
  2  select name, cell_num 
  3  from address_book;

View created.

SQL> select * from cell_view;

NAME                           CELL_NUM
------------------------------ ------------
Ben Rockwood                   650-555-2345
Tamarah Rockwood
Nova Rockwood