if i perform any operation on views such as insert, delete
etc will my base table get affected?????

Answer Posted / gourvendra singh

It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and types?

551


What is the unique index?

521


how does a local variable is defined using t-sql? : Transact sql

537


What is mutating sql table?

600


What is pl sql record in oracle?

557






Is primary key an index?

529


What is an alias command?

567


What is sql dialect?

521


tell me about various levels of constraint. : Sql dba

526


What is sql mysql pl sql oracle?

561


How can the performance of a trigger be improved?

588


How do I start sql profiler?

550


Explain the uses of a database trigger?

562


what is the functionality of the function htmlentities? : Sql dba

517


what is 'trigger' in sql? : Sql dba

553