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
Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship


Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check


What Command You Use What Day of the week were you born

What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive


In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu

what do you mean by consistency in rdbms?

Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu