Manipulating View

DMLLanguage and views
INSERT
UPDATE
DELETE

  1. Views can be selected

select * from views

 

INSERT INTO VIEWS

  • Views can be inserted into but they must have a primary key on that table. All the constrainsts that are needed must be available on that table
  • as a caution, only insert into one table at a time to avoid complications

UPDATING VIEWS

To prevent people from updating views, a  WITH READ ONLY must be added at the end of the create or replace update view script.

 

If you want to allow view within a certain constraint, we can add “WITH CHECK OPTION CONSTRAINT name_of_constraint”

 

Invisible Columns and Views

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top