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 is dynamic sql in pl sql?
What are all ddl commands?
Explian rowid, rownum? What are the psoducolumns we have?
Can a table have no primary key?
how to shut down the server with 'mysqladmin'? : Sql dba
Does view contain data?
What is java sql driver?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How do I view tables in sql developer?
How do you drop a trigger?
How do I audit the sql sent to the server?
What is the use of function "module procedure" in pl/sql?
How to make a copy values from one column to another in sql?
Which table is left in left join?
What is the difference between sql and t sql?