Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13240 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 are string functions in sql?
What is range partitioning?
Explain alias in sql?
Explain the significance of the & and && operators in pl sql.
What has stored procedures in sql and how we can use it?
What do you understand by pl/sql records?
What are different types of triggers?
What is the difference between partitioning and sharding?
What does (+) mean in sql joins?
How global cursor can be declare with dynamic trigger ?
What are the differences between implicit and explicit cursors?
How do you use collections in procedure to return the resultset?
explain primary keys and auto increment fields in mysql : sql dba
What are the dml statements?
how do you login to mysql using unix shell? : Sql dba
