Creating views with check option-data control, Database Management System

Creating views with check option: This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail:

Example: To produce a view for employees of Department = 30, such that user cannot alter the department number from the view:

CREATE OR REPLACE VIEW EMPD30 AS

SELECT EMPNO EMPL_NUM, ENAME NAME, SAL SALARY FROM EMP

WHERE DEPTNO=30

WITH CHECK OPTION;

 

Now the user cannot alter the department number of any record of view EMPD30. If this change is permitted then the record in which the change has been made will go off the view as the view is only for department-30. This restricted due to use of WITH CHECK OPTION clause

 

Posted Date: 3/11/2013 1:25:09 AM | Location : United States







Related Discussions:- Creating views with check option-data control, Assignment Help, Ask Question on Creating views with check option-data control, Get Answer, Expert's Help, Creating views with check option-data control Discussions

Write discussion on Creating views with check option-data control
Your posts are moderated
Related Questions
prototype of a distributed information system for a national car part retail outlet chain.

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

How to draw an ER diagram to a finance companz

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher


Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.