Murach's Oracle SQL and PL/SQL
How to create views

A view is a SQL SELECT statement that's stored as an object in the database. This chapter shows you how to create, manage, and use views.
Chapter 11 How to create views
An introduction to views 350
How views work 350
Benefits of using views 352
How to work with views 354
How to create a view 354
How to create an updatable view 358
How to create a read-only view 358
How to use the WITH CHECK OPTION clause 360
How to insert or delete rows through a view 362
How to alter or drop a view 364
How to use SQL Developer 366
How to get information about a view 366
How to drop a view 366
How to alter or create a view 366


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.