Can a view be updated/inserted/deleted?If Yes under what
conditions?
Answer Posted / swapnareddy
A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is percent sign in sql?
Is the primary key an index?
What are data types in pl sql?
what are the different type of normalization? : Sql dba
What is rownum and rowid?
what tools available for managing mysql server? : Sql dba
What is the difference between having and a where in sql?
What is the difference among union, minus and intersect?
how to decrement dates by 1 in mysql? : Sql dba
Why do we use procedures in pl sql?
What is sql stand for?
What is embedded sql what are its advantages?
What is the size of partition table?
describe transaction-safe table types in mysql : sql dba
what is oltp (online transaction processing)? : Sql dba