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
Why is a primary key important?
What is the life of an sql statement?
What is sql deadlock?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is a sql trace file?
What is primary key and foreign key?
Why do we need cursor in pl sql?
What is full join in sql?
what is oltp (online transaction processing)? : Sql dba
what is clause? : Sql dba
What are tuples in sql?
how do you tune the slow running queries in oracle db , explain the methodology
What are the packages in pl sql?
What is a composite primary key?
Can we commit inside a trigger?