Oracle 1Z0-007: Creating Views

Creating Views

Describe a view

A view is virtual table of data, where a table is a table of data.

Create, alter the definition, and drop a view


				/*create view*/

				create view view_name AS

				select column_name(s)

				from table_name

				where condition


				/*alter view*/

				alter view all_authors (au_fname, au_lname, address, city, zip)

				AS

				select au_fname, au_lname, address, city, zip

				from pubs..authors

				where state = 'ut'


				/*delete view*/

				delete view pubs_view

Retrieve data through a view

/*get data from a view*/

				select * from pubs_view;

Insert, update and delete data through a view

/*insert into a view*/

				insert into pubs_view (first_name, last_name, address) values('reggie', 'jackson', 'yankee stadium, 161st Street Bronx, NY 10451')


				/*update data in a view*/

				update pubs_view

				set first_name = 'reginald'

				where last_name = 'jackson'


				/*delete data from a view*/

				delete from pubs_view

				where last_name = 'mcdowell'

Updated: May. 1, 2005; Joe Gakenheimer

Updated: July 30, 2005; Joe Gakenheimer