Interested to Buy Any Domain ? << Click Here >> for more details...
Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13974 Views
- I also Faced
- E-Mail Answers
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 sql query optimization?
Differentiate between syntax and runtime errors.
what are the different functions in sorting an array? : Sql dba
What is dialect in sql?
When can we use the where clause and the having clause?
what are date and time data types? : Sql dba
What does (*) mean in sql?
what is self-join? : Sql dba
What is substitution variable in pl sql?
Which query operators in sql is used for pattern matching?
what is primary key? : Sql dba
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the types of optimization?
what is 'mysqlshow'? : Sql dba
What is sql constant?
