Can a view be updated/inserted/deleted?If Yes under what
conditions?
Answer Posted / guest
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 not possible.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What does truncate mean in sql?
What is trigger in pl sql?
What does pl sql developer do?
What is auto increment in sql?
What is sap sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
Is sql easier than java?
What is sql clause?
What is the difference between nested table and varray?
Are subqueries better than joins?
What are the qualities of 2nf?
What is a recursive join sql?
What are joins in sql?
what is an alias command? : Sql dba
What are sql functions? Describe the different types of sql functions?